当远程连接数据库发现连接不上,提示Host is not allowed to connect to this MySQL server时
解决办法:
授权法:
1.进入mysql下插入,例如 user使用密码‘password’从任何主机连接到mysqld服务器的话。
(1)GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
(2)例如:root使用密码‘password’ 从ip为:192.168.1.3主机连接到mysqld服务器
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.3' IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql>flush privileges;
(mysql 新设置用户或更改密码后需用flush privileges刷新MySQL的系统权限相关表,否则会出现拒绝访问或着重新启动mysql服务器,来使新设置生效)