问题:
远程连接服务器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;
最后:完事~