- 转到mysql库
use mysql;
- 查看mysql用户信息:
select User,Host from user;
- 修改mysql root用户信息,并授予权限
update user set host = % where user = root;
grant all privileges on *.* to root@'%' with grant option;
flush privileges;
- 再次查看mysql用户信息:
select User,Host from user;