控制台启动mysql:
%mysql_path%/bin/mysqld --console
修改初始密码:
%mysql_path%/bin/mysql -u root;
use mysql;
update user set password=password('新密码') where user='root'
flush privileges;
添加win服务:
把my-default.ini改城my.ini
# These are commonly set, remove the # and set as required.
basedir = D:/mysql-5.6.20-winx64
datadir = D:/mysql-5.6.20-winx64\data
[WinMySQLAdmin]
Server=D:/mysql-5.6.20-winx64/bin/mysqld.exe
[client]
default-character-set=utf8
cmd:
添加服务:%mysql_path%/bin/mysqld --install MYSQL --defaults-file="D:\mysql-5.6.20-winx64\my.ini";
删除服务:%mysql_path%/bin/mysqld --remove