Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to check the mysql account password, has a certain reference value, friends in need can refer to. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

Find the method: first run a cmd window as an administrator, enter "mysql-uroot-p", enter into the database, and then use the "select host,user,password from mysql.user;" command to see the account and password.

Let's show you how to check the user name and password of mysql after installing mysql.

Methods:

Under windows

1. Run cmd. Net as a system administrator.

two。 Check to see if mysql has been started, and if so, stop: net stop mysql.

3. Switch to the MySQL installation path: d:\ WAMP\ MySQL-5.6.36\ bin; if you have already configured the environment variable, you don't have to switch.

4. On the command line, enter: mysqld-nt--skip-grant-tables

5. Restart to run a cmd as an administrator, and type: mysql-uroot-pcent enter to enter the database.

6. If you find the mysql account password, you can execute this statement on the command line

Select host,user,password from mysql.user;// can see the user and password. Thank you for reading this article carefully. I hope the editor can share how to check the password of mysql account and what is helpful to everyone. At the same time, I also hope you can support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are 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.