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 @ 2020-06-18 14:23  tommy~hi  阅读(2752)  评论(0编辑  收藏  举报