How to check what the current password of mysql is

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

How to view the current password of mysql:

If the login is successful, the following information will be displayed

After entering, we can execute select * from mysql.user;Query mysql user information, you can see that the password is encrypted

So, if you have set a password but forgotten it, sorry, you cannot view the password, you can only view the user name, because the MySQL password is dynamic md5 encryption and cannot be reversibly queried

More related free learning recommendations: mysql tutorial(Video)

The above is the detailed content of How to check what the current password of mysql is. For more information, please follow other related articles on the PHP Chinese website!