mysql主主复制+keepalived高可用(使用VIP访问数据库提示不允许连接)
程序员文章站
2022-05-19 23:50:24
...
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)!