问题:
远程连接服务器mysql出现:
ERROR 1130 (HY000): Host ‘xxx.xxx.xxx.xxx’ is not allowed to connect to this MySQL server
解决:
1.命令行输入 :mysql -u -root -p
然后输入密码
2.然后输入sql语句:GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '数据库密码' WITH GRANT OPTION;
3.接着输入语句:flush privileges;
最后:完事~
如果觉得《远程连接mysql出现ERROR 1130 (HY000): Host ‘xxx.xxx.xxx.xxx’ is not allowed to connect to this MySQL server》对你有帮助,请点赞、收藏,并留下你的观点哦!