MySQL primary master replication +keepalived high Availability (use VIP to Access database prompts not to allow connections)

ERROR 1130 (HY000): Host ' Nginx-vip ' isn't 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

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)

This article comes from "Everything must be causal." "Blog, be sure to keep this provenance http://gaorui1989.blog.51cto.com/4016591/1716836

MySQL primary master replication +keepalived high Availability (use VIP to Access database prompts not to allow connections)