第1个回答 2013-03-13
修改当前登录用户的密码: (也就是修改自己的密码)
mysql> SET PASSWORD = PASSWORD('test');
Query OK, 0 rows affected (0.00 sec)
mysql> select host, user, password from mysql.user;
+-----------+------+-------------------------------------------+
| host | user | password |
+-----------+------+-------------------------------------------+
| localhost | root | |
| localhost | | *94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29 |
+-----------+------+-------------------------------------------+
2 rows in set (0.00 sec)
不知道你 查询的, 是不是 mysql.user 这个表?