# These are commonly set, remove the # and set as required.
basedir = "D:\Program Files\mysql-5.6.24-win32"
datadir = "D:\Program Files\mysql-5.6.24-win32\data"
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');