如何在mysql里查看主机、用户名、密码的设置情况??

Question

如何在mysql里查看主机、用户名、密码的设置情况??

Answer 1

mysql> select host,user,password from mysql.user;
+-----------+---------+-------------------------------------------+
| host      | user    | password                                  |
+-----------+---------+-------------------------------------------+
| localhost | root    | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |
| localhost | afdwe   | *E6CC90B878B948C35E92B003C792C46C58C4AF40 |
| localhost | dfsd    | *E6CC90B878B948C35E92B003C792C46C58C4AF40 |
| %         | sdfsdf  | *00A51F3F48415C7D4E8908980D443C29C69B60C9 |
| %         | aaadfe  | *13F9536FF36FEA8F67E07DC30BC06D86AE67CB75 |
| %         | adfe    | *00A51F3F48415C7D4E8908980D443C29C69B60C9 |
+-----------+---------+-------------------------------------------+
6 rows in set (0.06 sec)mysql>

Answer 2

参考一下这个贴子,如何恢复你的ROOT的密码。
http://topic.csdn.net/u/20090515/21/2b3c9a12-d8a5-4bb1-9895-6069cef5aef8.html