linux下修改mysql访问权限

1.登录mysql

./mysql -uroot -prootpw

2.选择库，查看权限

mysql> use mysql;
Database changed
mysql> SELECT `Host`,`User`FROM user;

3.修改权限

update user set Host='%' where User='root' limit 1;

 

4.刷新权限

flush privileges;