MYSQL绿色安装过程

# These are commonly set, remove the # and set as required.
basedir = "D:Program Filesmysql-5.6.24-win32"
datadir = "D:Program Filesmysql-5.6.24-win32data"
port = 3306
character_set_server=utf8
# server_id = .....

在安装的时候如果遇到install/remove of the service denied!错误的。需要将cmd.exe以管理员的方式运行。

MySQL修改root密码

用SET PASSWORD命令

　　mysql -u root

　　mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');