Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to check the mysql user name and password, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian take you to understand.

View the mysql user name and password: 1, open the "start" menu, find and open the MySql command window; 2, enter the password, log on to the mysql server; 3, execute the "select * from mysql.user" command to see the user name and password in the output.

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

View the username and password of the local mysql

1. Click the MySql key to find the following figure in Windows, and click.

2. Click and appear as shown in the following figure. Enter the password.

3. After entering the password, it appears as shown below.

4. Enter: select * from mysql.user; to find the user name and password. The username and password shown in the following figure

The user name is: root

The password is: MD5 encrypted dynamic code, can not be broken.

Thank you for reading this article carefully. I hope the article "how to check the user name and password of mysql" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support and follow the industry information channel. More related knowledge is waiting for you to learn!

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.