keepalived vip mysql_mysql主主复制+keepalived高可用（使用VIP访问数据库提示不允许连接）...

mysql主主复制+keepalived高可用(使用VIP访问数据库提示不允许连接)_MySQL

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)

以上就是mysql主主复制+keepalived高可用(使用VIP访问数据库提示不允许连接)_MySQL的内容，更多相关内容请关注PHP中文网(www.php.cn)！

本文原创发布php中文网，转载请注明出处，感谢您的尊重！