MySQL 1130错误原因及解决方案

• 客户端程序使用ip连接数据库的时候会报1130错误:ERROR 1130: Host ‘xxx.xxx.xxx.xxx’ is not allowed to connect to thisMySQL serve
• 原因是mysql主机地址默认是localhost(127.0.0.1)连接
• 修改方法有以下几种:

1. 用本地地址连接后把地址修改为远程客户端的地址:
   use mysql;
update user set host='xxx.xxx.xxx.xxx';
2. 修改用户表
   mysql -u root -pvmware
mysql>use mysql;
mysql>update user set host = '%' where user = 'root';
mysql>flush privileges;
mysql>select host, user from user
3. 授权

• 授权ip:
  GRANT ALL PRIVILEGES ON *.* TO 'mysqluser'@'192.168.47.1' IDENTIFIED BY 'mysqlpassword' WITH GRANT OPTION;
• 授权用户:
  GRANT ALL PRIVILEGES ON *.* TO 'mysqluser‘@'%' IDENTIFIED BY 'mysqlpassword' WITH GRANT OPTION;