安装文件: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的详细内容...