[MySQL故障] ERROR 1045 (28000): Access denied for user 'mmm_agent'@'exxx-tx.com' (using password: YES)
?
1 error登陆错误
[python]?
[uxxx@exxx-0702 ~]$
mysql -hexxx-tx.com --user='mmm_agent' --password='#tx$' ?
ERROR 1045 (28000): Access denied for user 'mmm_agent'@'exxx-tx.com' (using password: YES) ?
?
2 去掉-h参数,能顺利登陆?
[python]?
[uxxx@exxx-0702 ~]$ mysql --user='mmm_agent' --password='#tx$' ?
Welcome to the MySQL monitor. ?Commands end with ; or \g. ?
Your MySQL connection id is 491 ?
Server version: 5.x.xa-log MySQL tx Reltxse ?
??
Copyright (c) 2000, 2011,
Oracle and/or its affiliates. All rights reserved. ?
??
Oracle is a registered trademark of Oracle Corporation and/or its ?
affiliates. Other names may be trademarks of their respective ?
owners. ?
??
??
Type 'help;' or '\h' for help. Type '\c' to cltxr the current input statement. ?
??
??
mysql> ?
?
3 难道是对于-h参数有限制?我换个用户试试看
[sql]?
mysql> GRANT ALL PRIVILEGES ON *.* TO 'mg'@'%' IDENTIFIED BY '#tx$'; ?
Query OK, 0 rows affected (0.01 sec) ?
??
??
mysql> exit ?
[uxxx@exxx-0702 ~]$ mysql -hexxx-tx.com --user='mg' --password='#tx$' ?
Welcome to the MySQL monitor. ?Commands end with ; or \g. ?
Your MySQL connection id is 965 ?
Server version: 5.x.xa-log MySQL tx Reltxse ?
??
??
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. ?
??
??
Oracle is a registered trademark of Oracle Corporation and/or its ?
affiliates. Other names may be trademarks of their respective ?
owners. ?
??
Type 'help;' or '\h' for help. Type '\c' to cltxr the current input statement. ?
??
??
mysql> ??
?
看来不是对于-h参数的限制问题，应该是别的故障，密码是OK的。
?
?
4 去查看mmm_agent用户吧。
[sql]?
mysql> select user,host from mysql.user where user='mmm_agent'; ?
+-----------+------+ ?
| user ? ? ?| host | ?
+-----------+------+ ?
| mmm_agent | % ? ?| ?
| mmm_agent | 10.% | ?
+-----------+------+ ?
2 rows in set (0.00 sec) ?
??
??
mysql> show grants for mmm_agent@'%'; ?
+-------------------------------------------------------------------------------------------------------------------+ ?
| Grants for mmm_agent@% ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?| ?
+-------------------------------------------------------------------------------------------------------------------+ ?
| GRANT ALL PRIVILEGES ON *.* TO 'mmm_agent'@'%' IDENTIFIED BY PASSWORD '*77074D8AC9603904375ED54F1D2E14CDACB7842F' | ?
+-------------------------------------------------------------------------------------------------------------------+ ?
1 row in set (0.00 sec) ?
??
??
mysql> show grants for mmm_agent@'10.%'; ?
+--------------------------------------------------------------------------------------------------------------------------------------------------+ ?
| Grants for mmm_agent@10.% ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?| ?
+--------------------------------------------------------------------------------------------------------------------------------------------------+ ?
| GRANT RELOAD, PROCESS, SUPER, REPLICATION CLIENT ON *.* TO 'mmm_agent'@'10.%' IDENTIFIED BY PASSWORD '*6745119376CF6BD5E0F0A50484A91AE7BD172612' | ?
| GRANT EXECUTE ON `audit`.* TO 'mmm_agent'@'10.%