网站建设知识
mysql主主复制+keepalived高可用(使用VIP访问数据库提示不允许连接)
2025-07-22 09:56  点击:0
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 -ADatabase 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)