How to check mysql username and password

How to check the mysql user name and password: First log in to the mysql server; then execute the [select * from mysql.user;] statement to output the user name and password.

Specific method:

(Recommended tutorial: mysql tutorial)

First log in to mysql, If the login is successful, the following information will be displayed

Then execute the sql statement

select * from mysql.user;

You can see that the password is encrypted.

Related recommendations: php training

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