Shulou(Shulou.com)05/31 Report--

This article mainly explains the "mysql database password forgot how to do", the article explains the content is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in-depth, together to study and learn "mysql database password forgot how to do" it!

The password problem of mysql

Today, when I was using the database in the experiment, I forgot my password, which made me look for it for a long time:

Now I would like to introduce to you my own method: using mysql's own function to test.

[html]

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") | www.2cto.com |

+-+

| | 67457e226a1a15bd |

+-+

1 row in set (0.00 sec)

Mysql > select password ("chen")

+-+

| | password ("chen") |

+-+

| | 309e1248634a4f61 |

+-+

1 row in set (0.00 sec)

Thank you for your reading, the above is the "mysql database password forgot how to do" the content, after the study of this article, I believe you forget how to do the mysql database password has a deeper understanding of this problem, the specific use of the situation also needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.