基于mysql数据库的密码问题详解_Mysql_脚本之家

今儿在做实验用到mysql数据库时,用户密码忘记了,让我也是找了半天:现在给大家介绍下我自己的方法:用到了mysql自身的函数来测试的。复制代码 代码如下:mysql> select
user,password,host from user;+——+——————+———–+|
user | password | host |+——+——————+———–+| root |
773359240eb9a1d9 | localhost || root | | fsailing1 || root | | 127.0.0.1
|| root | 309e1248634a4f61 | % |+——+——————+———–+4
rows in set

mysql> password;ERROR 1064 : You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near ‘password’ at line 1mysql> select
password;+——————+| password |+——————+|
67457e226a1a15bd |+——————+1 row in set

mysql> select password;+——————+| password
|+——————+| 309e1248634a4f61 |+——————+1 row in
set

You can leave a response, or trackback from your own site.

Leave a Reply

网站地图xml地图