基于mysql数据库的密码问题详解

前端技术 2023/09/06 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 (0.00 sec)

mysql> password(\"root\");
ERROR 1064 (42000): 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(\"root\")\' at line 1
mysql> select password(\"root\");
+------------------+
| password(\"root\") |
+------------------+
| 67457e226a1a15bd |
+------------------+
1 row in set (0.00 sec)

mysql> select password(\"chen\");
+------------------+
| password(\"chen\") |
+------------------+
| 309e1248634a4f61 |
+------------------+
1 row in set (0.00 sec)

本文地址：https://www.stayed.cn/item/15666

转载请注明出处。

本站部分内容来源于网络,如侵犯到您的权益,请 联系我

我的博客

人生若只如初见，何事秋风悲画扇。

我的标签

随笔档案