MHA高可用启动报错集合

错误1

[error][/usr/local/share/perl5/MHA/ServerManager.pm, ln301] Got MySQL error when connecting 20.0.0.23(20.0.0.23:3306) :1130:Host ‘20.0.0.21’ is not allowed to connect to this MySQL server, but this is not a MySQL crash. Check MySQL server settings.
at /usr/local/share/perl5/MHA/ServerManager.pm line 297.
Sun Nov 1 15:09:09 2020 - [error][/usr/local/share/perl5/MHA/ServerManager.pm, ln301] Got MySQL error when connecting 20.0.0.24(20.0.0.24:3306) :1130:Host ‘20.0.0.21’ is not allowed to connect to this MySQL server, but this is not a MySQL crash. Check MySQL server settings.
at /usr/local/share/perl5/MHA/ServerManager.pm line 297.
Sun Nov 1 15:09:14 2020 - [error][/usr/local/share/perl5/MHA/ServerManager.pm, ln309] Got fatal error, stopping operations
Sun Nov 1 15:09:14 2020 - [error][/usr/local/share/perl5/MHA/MasterMonitor.pm, ln427] Error happened on checking configurations. at /usr/local/share/perl5/MHA/MasterMonitor.pm line 329.
Sun Nov 1 15:09:14 2020 - [error][/usr/local/share/perl5/MHA/MasterMonitor.pm, ln525] Error happened on monitoring servers.
Sun Nov 1 15:09:14 2020 - [info] Got exit code 1 (Not master dead).

MySQL Replication Health is NOT OK!

修改：
在所有数据库节点上授权两个用户，一个是从库同步使用，另外一个是 manager 使用。

mysql> grant replication slave on *.* to 'myslave'@'20.0.0.%' identified by '123';
mysql> grant all privileges on *.* to 'mha'@'20.0.0.%' identified by 'manager';
mysql> flush privileges;

错误2

[error][/usr/local/share/perl5/MHA/Server.pm, ln398] 20.0.0.23(20.0.0.23:3306): User myslave does not exist or does not have REPLICATION SLAVE privilege! Other slaves can not start replication from this host.
Sun Nov 1 15:16:23 2020 - [error][/usr/local/share/perl5/MHA/MasterMonitor.pm, ln427] Error happened on checking configurations. at /usr/local/share/perl5/MHA/ServerManager.pm line 1403.
Sun Nov 1 15:16:23 2020 - [error][/usr/local/share/perl5/MHA/MasterMonitor.pm, ln525] Error happened on monitoring servers.
Sun Nov 1 15:16:23 2020 - [info] Got exit code 1 (Not master dead).

MySQL Replication Health is NOT OK!

修改方法：
备用主服务器没有复制的权限
在主备服务器上加权限

grant all privileges on *.* to 'mha'@'20.0.0.%' identified by 'manager';