(using password: YES), but this is not a MySQL crash. Check MySQL server settings.

Question

mysql5.7 MHA测试主从同步配置失败（MySQL Replication Health is NOT OK!）
环境：Linux、maxscale+mysql一主两从+MHA
mha测试ssh免密登录配置成功状态

[root@mha mha]# masterha_check_repl --conf=/etc/mha/app1.cnf
Fri Aug 18 16:10:11 2023 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping.
Fri Aug 18 16:10:11 2023 - [info] Reading application default configuration from /etc/mha/app1.cnf..
Fri Aug 18 16:10:11 2023 - [info] Reading server configuration from /etc/mha/app1.cnf..
Fri Aug 18 16:10:11 2023 - [info] MHA::MasterMonitor version 0.56.
Fri Aug 18 16:10:11 2023 - [error][/usr/local/share/perl5/MHA/ServerManager.pm, ln301] Got MySQL error when connecting 192.168.20.57(192.168.20.57:3306) :1045:Access denied for user 'myaqla'@'192.168.20.42' (using password: YES), but this is not a MySQL crash. Check MySQL server settings.
at /usr/local/share/perl5/MHA/ServerManager.pm line 297.
Fri Aug 18 16:10:11 2023 - [error][/usr/local/share/perl5/MHA/ServerManager.pm, ln301] Got MySQL error when connecting 192.168.20.59(192.168.20.59:3306) :1045:Access denied for user 'myaqla'@'192.168.20.42' (using password: YES), but this is not a MySQL crash. Check MySQL server settings.
at /usr/local/share/perl5/MHA/ServerManager.pm line 297.
Fri Aug 18 16:10:11 2023 - [error][/usr/local/share/perl5/MHA/ServerManager.pm, ln301] Got MySQL error when connecting 192.168.20.58(192.168.20.58:3306) :1045:Access denied for user 'myaqla'@'192.168.20.42' (using password: YES), but this is not a MySQL crash. Check MySQL server settings.
at /usr/local/share/perl5/MHA/ServerManager.pm line 297.
Fri Aug 18 16:10:12 2023 - [error][/usr/local/share/perl5/MHA/ServerManager.pm, ln309] Got fatal error, stopping operations
Fri Aug 18 16:10:12 2023 - [error][/usr/local/share/perl5/MHA/MasterMonitor.pm, ln424] Error happened on checking configurations. at /usr/local/share/perl5/MHA/MasterMonitor.pm line 326.
Fri Aug 18 16:10:12 2023 - [error][/usr/local/share/perl5/MHA/MasterMonitor.pm, ln523] Error happened on monitoring servers.
Fri Aug 18 16:10:12 2023 - [info] Got exit code 1 (Not master dead).

MySQL Replication Health is NOT OK!

Answer 1

【以下回答由 GPT 生成】

这个问题的错误信息显示是"Access denied for user 'myaqla'@'192.168.20.42' (using password: YES)"，意味着连接MySQL数据库时用户名或密码错误。下面是可能的解决方案：

1. 检查数据库用户名和密码是否正确：确认mha配置文件中的MySQL用户名和密码与实际的MySQL账号和密码是否一致，确保没有拼写错误。
2. 检查MySQL服务器的设置：在MySQL服务器上确认是否已启用远程访问，并授予了正确的IP地址访问权限。确保MySQL服务器的my.cnf配置文件中的bind-address参数设置为适当的IP地址，或者设置为0.0.0.0以允许从任何IP地址访问。
3. 检查网络连接：确保主从数据库服务器之间的网络连接畅通，并且可以相互访问。可以尝试使用telnet或ping命令测试主从数据库服务器之间的连接是否正常。
4. 检查防火墙设置：如果有防火墙，确认是否已允许通过MySQL的TCP端口(默认为3306)进行连接。可以使用iptables命令来添加相应的规则。
5. 检查主从数据库服务器的时间同步：如果主从数据库服务器的系统时间存在较大差异，可能会导致认证失败。确保主从数据库服务器的系统时间同步。

以上是解决该问题的一些常见方法，请尝试逐步检查和排除以上可能的问题。如果问题仍然存在，可能需要更详细的日志信息或其他配置文件内容来进一步分析和解决。

如果你已经解决了该问题, 非常希望你能够分享一下解决方案, 写成博客, 将相关链接放在评论区, 以帮助更多的人 ^-^