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

Editor to share with you the mysql database administrator password forgot how to do, I believe that most people do not know much, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

We use the MySQL database when programming under the Windows operating system. But sometimes we forget the login password of the database? What should we do when we forget our login password and can't get into mysql? Here we provide changes to mysql's login secret.

1. Enter the command mysqld-- skip-grant-tables (as long as the process net stop mysql of mysql.exe is closed)

two。 Enter the command mysql

Complete database entry without password ~

3. Change username and password

Mysql-uroot-p1234

Red for changeable places, user name and password

The above is the mysql database administrator password forgot how to do all the content, thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.