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

This article is to share with you about mysql forgot the password how to do, the editor feels very practical, so share with you to learn, I hope you can learn something after reading this article, do not say much, follow the editor to have a look.

What if mysql forgets his password?

1. Open mysql.exe and enter the mysql.exe path address

two。 Run under the DOS window:

Mysqld-skip-grant-tables

3. Close the previous window and continue running mysql under the DOS window

4. To change the root password, run:

Update user set password=password ('123456') where user='root' and host='localhost'

5. After changing the password, restart mysql and log in with the new password

MySQL is a relational database management system developed by the Swedish company MySQL AB and belongs to the products of Oracle. MySQL is one of the most popular relational database management systems. In the aspect of WEB application, MySQL is one of the best RDBMS (Relational Database Management System) application software. MySQL is a relational database management system in which relational databases store data in different tables instead of all data in one large warehouse, which increases speed and flexibility.

This is what mysql does when he forgets his password. The editor believes that some of the knowledge points may be seen or used in our daily work. I hope you can learn more from this article. For more details, please 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.