故障：ERROR 1045 (28000): Access denied for user 'mha'@'server2' (using password: YES) mysql command failed with rc 1:0!

错误说明：

MHA健康检查时报错，具体报错信息如下

ERROR 1045 (28000): Access denied for user 'mha'@'server2' (using password: YES)
mysql command failed with rc 1:0!

原因分析：

1、密码输入错误

重新对授权密码进行确认，密码无误

2、通过排查发现报错的信息使用的是主机名，而我进行授权的是一个网段

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

而报错的显示是server2

ERROR 1045 (28000): Access denied for user 'mha'@'server2' (using password: YES)

解决：

将授权改成主机名

grant all privileges on *.* to 'mha'@'server2' identified by '123123';

重新授权后MHA健康检查正常