好得很程序员自学网

<tfoot draggable='sEl'></tfoot>

MySQLInstallerGUI-图解 - mysql数据库栏目 - 自学php

安装文件:mysql-installer-community-5.6.16.0.msi

首先,确定已经安装了.net4.0+

然后,根据官方文档安装 vc D4KPHA+ICAgINDo0qrXotLitcSyv7f WP C9wPgo8cD48aW1nIHNyYz0="http://www.2cto.com/uploadfile/Collfiles/20140312/2014031209081312.jpg" alt="\">

自定义安装

安装依赖(VS2008*-VS2012;.net4.0+;VC10运行库;)

下载和安装

安装成功

配置用户 - 2

配置用户 - 3*

配置MySQL5.5完成

配置简单示例完成

*2. 角色说明(Role name)

(1) Backup Admin:

a) EVENT

b) LOCK TABLES

c) SELECT

d) SHOW DATABASES

(2) DB Admin:

ALL

(3) DB Designer:

a) ALTER

b) ALTER ROUTINE

c) CREATE

d) CREATE ROUTINE

e) CREATE VIEW

f) INDEX

g) SHOW DATABASES

h) SHOW VIEW

i) TRIGGER

(4) DB Manager:

BackupAdmin (1) + DBDesigner(3)

and

a) CREATE TEMPORARY TABLES

b) DELETE

c) DROP

d) GRANT OPTION

e) INSERT

f) UPDATE

(5) Instance Manager:

(MaintenanceAdmin)

ProcessAdmin(7)

and

a) EVENT

b) SHOW DATABASES

c) SHUTDOWN

(6) Monitor Manager:

a) PROCESS

(7) Process Admin:

a) RELOAD

b) SUPER

(8) Replication Admin:

a) REPLICATION CLIENT

b) REPLICATION SLAVE

c) SUPER

(9) Security Admin:

UserAdmin(10)

and

a) GRANT OPTION

b) SHOW DATABASES

(10) User Admin:

a) CREATE USER

b) RELOAD

查看更多关于MySQLInstallerGUI-图解 - mysql数据库栏目 - 自学php的详细内容...

  阅读:43次