安裝文件:mysql-installer-community-5.6.16.0.msi
數 據 庫:V5.5.36
首先,確定已經安裝了.net4.0+
然後,根據官方文檔安裝<喎?http://www.Bkjia.com/kf/ware/vc/" target="_blank" class="keylink">vcD4KPHA+ICAgINDo0qrXotLitcSyv7fWPC9wPgo8cD48aW1nIHNyYz0="http://www.2cto.com/uploadfile/Collfiles/20140312/2014031209081312.jpg" alt="\">
自定義安裝
不安裝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