mysql主主複製+keepalived高可用（使用VIP訪問資料庫提示不允許串連）

標籤：mysql   error 1130 (hy000)   

ERROR 1130 (HY000): Host ‘nginx-vip‘ is not allowed to connect to this MySQL server

mysql> GRANT ALL PRIVILEGES ON *.* TO ‘slave‘@‘192.168.0.232‘ IDENTIFIED BY ‘slave‘ WITH GRANT OPTION;

Query OK, 0

mysql> use mysql;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> select user,host from user;

+-------+---------------+

| user  | host          |

+-------+---------------+

| root  | %             |

| root  | 127.0.0.1     |

| slave | 192.168.0.231 |

| slave | 192.168.0.232 |

| root  | ::1           |

|       | localhost     |

|       | nginx01       |

| root  | nginx01       |

+-------+---------------+

8 rows in set (0.00 sec)

本文出自 “凡事必有因果。” 部落格，請務必保留此出處http://gaorui1989.blog.51cto.com/4016591/1716836

mysql主主複製+keepalived高可用（使用VIP訪問資料庫提示不允許串連）