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 @   tommy~hi  阅读(2813)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示