What to do if you forget your password in MySQL 5.7.17

1. Add skip-grant-tables to the my.ini file and restart the MySQL server

2. Enter cmd as an administrator, or use a database management tool. I use navicat to connect to the database.

Fill in the connection name casually, leave the password blank, and click OK

3. Double-click the MySQL database, click the menu bar query, and create a new query

4. Execute update user set authentication_string = password('root') where user = 'root'

5. Comment out or delete skip-grant-tables in the my.ini file

6. Restart the Mysql server. The password of user root will become root.

You can refer to the following MySQL topics provided by this site:

Mysql installation tutorials in various systems

Mysql Root Password Operation Skills

MySql Database Getting Started Tutorial

Summary of database operation knowledge in MySQL

The above is what I introduced to you about Mysql 5.7.17 forgotten password. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!