mysql installer图解_MySQL Installer GUI - 图解

数  据  库：V5.5.36

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

然后，根据官方文档安装

需要注意的部分

自定义安装

不安装MySQL5.6

选择MySQL5.5

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

下载和安装

安装成功

配置用户 - 1

配置用户 - 2

配置用户 - 3*

配置MySQL5.5完成

配置简单示例完成

*1. 不建议使用VS2008

*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