ERROR 1045 (28000): Access denied for user ‘mha‘@‘server‘ (using password: YES)

报错原因

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

健康检查中显示拒绝授权

解决办法

mysql> grant all privileges on *.* to 'mha'@'server' identified by 'manager';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

授权并刷新权限

健康检查成功