mysql远程授权

切换到mysql的mysql数据库，找到user表；

cmd:mysql -u root -p

cmd:use mysql;

cmd:select host,user,password from user;

更新user表信息：

cmd:update user set host = '%' where user = 'root';

为root用户授权密码为root：

cmd:grant all privileges on *.* to root@'%' identified by 'root';

刷新权限：

cmd:flush privileges;

 

转载于:https://www.cnblogs.com/zouchengli/p/6860728.html