方法一:该表法(将user表中的host项的"localhost"修改成"%")
mysql -uroot -p(进入mysql)
use mysql;
update user set host = '%' where user = 'root';
select host,user from user;
方法二:授权法
启动MySQL并登录
授权任何主机访问数据库权限
grant all privrileges on *.* to 'root'@'%' with grant option
设置某个用户登录数据库服务(user用户通过password密码登录数据库服务)
grant all privrileges on *.* to '登录用户名(user)'@'%' identified by '指定的密码(password)' with grant option
指定特定的ip地址访问(允许ip为192.168.77.01且用户为user的用户以password密码登录)
grant all privrileges on *.* to '登录用户名(user)'@'192.168.77.01' identified by '指定的密码(password)' with grant option
使修改生效
flush privrileges