How to check the username and password of mysql

How to check the mysql username and password: 1. Open the "Start" menu, find and open the MySql command window; 2. Enter the password and log in to the mysql server; 3. Execute the "select * from mysql.user" command You can view the username and password in the output results.

The operating environment of this tutorial: windows10 system, mysql8 version, Dell G3 computer.

View the local mysql username and password

1. Click the Windows key and find the MySql as shown below, Click.

#2. After clicking, the following picture will appear. Enter the password.

#3. After entering the password, the following picture will appear.

4. Enter: select * from mysql.user; to find the username and password. The username and password shown below appear

The username is: root

The password is: MD5 encrypted dynamic code, which cannot be cracked.

[Related recommendations: mysql video tutorial]

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