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

What if I forget the root password of the mysql server? I believe that many inexperienced people are at a loss about this, so this article summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

What if the mysql server root password is forgotten?

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.

After reading the above, have you forgotten how to master the root password of the mysql server? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

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.