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!