windows下mysql开启远程访问权限

1、mysql -u root -p

2、use mysql

3、GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;

4、flush privileges;

5、select host,user from user;

posted @ 2015-11-16 13:23  青羽  阅读(3498)  评论(0编辑  收藏  举报