windows下mysql一些问题

控制台启动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

转载于:https://my.oschina.net/walter/blog/341196