MHA检测主从复制状态的时出现“User xxx does not exist or does not have REPLICATION SLAVE privi

MHA检测主从复制状态的时出现“User xxx does not exist or does not have REPLICATION SLAVE privilege”异常解决

注意：本文出自 “阿飞”的博客 ，如果要转载本文章，请与作者联系！并注明来源: http://blog.csdn.net/faye0412/article/details/7978697

MYSQL-Master-HA检测主从复制状态的时出现“User xxx does not exist or does not have REPLICATION SLAVE privilege”异常：

mysql> SELECT user,host,password, Repl_slave_priv AS Value FROM mysql.user WHERE user = 'repl';+-------+-------------+-------------------------------------------+-------+| user  | host        | password                                  | Value |+-------+-------------+-------------------------------------------+-------+| repl  | %           | *027*****6D8E759C6F4352B*********8465B8F8 | N     || repl  | 192.168.1.% | *027*****6D8E759C6F4352B*********8465B8F8 | Y     |+-------+-------------+-------------------------------------------+-------+2 rows in set (0.00 sec)

一下我就明白了，原来我创建复制帐号的时候创建了两个repl，而权限分配的不一样。问题终于找到了。于是我把第一个删掉，问题解决。

很多时候各种问题的出现都是由于自己的大意啊。其实在这篇文章之前应该还有一篇MYSQL-Master-HA的安装和配置篇以及各种问题解决的文章。这个只能延后了，忙....