Shulou(Shulou.com)06/01 Report--

How to check the current password of mysql? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

How to check the current password of mysql: first, log in to mysql; successfully, then enter and execute the statement [select * from mysql.user;]; finally, query the user information of mysql, and you can see that the password is encrypted.

How to view the current password of mysql:

If the login is successful, the following information is displayed

After entering, we can execute select * from mysql.user; to query the user information of mysql. We can see that the password is encrypted.

So, if you set the password but forget it, I'm sorry, you can't check the password, you can only check the user name, because the mysql password is dynamically md5 encrypted and cannot be queried in reverse.

Thank you for reading! After reading the above, do you have a general idea of how to check the current password of mysql? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.

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.