Mysql master/master replication + keepalived high availability (using VIP to access the database prompts that connection is not allowed)

This article describes the high availability of mysql master/master replication + keepalived (using VIP to access the database prompts that connection is not allowed), which has some reference value. let's take a look at it. Mysql master-master replication + keepalived high availability (using VIP to access the database prompts that connection is not allowed) _ MySQL

ERROR 1130 (HY000): Host 'nginx-vip' is not allowed to connect to this MySQL servermysql> GRANT ALL PRIVILEGES ON *.* TO 'slave'@'192.168.0.232' IDENTIFIED BY 'slave' WITH GRANT OPTION;Query OK, 0mysql> use mysql;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -A Database changedmysql> 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)

The above is the content of _ mysql in MySQL master replication + keepalived high availability (the VIP is used to access the database and the prompt is not allowed to connect). For more information, see PHP Chinese network (www.php1.cn )!