Share the solution to solve the problem of forgotten password in Mysql5.7.17 (picture)

This article mainly introduces the solution to Mysql 5.7.17 forgotten password. Friends in need can refer to

1. Add skip-grant- in the my.ini file tables, restart the MySQL server

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

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

3. Double-click

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. Go to the my.ini file Comment out or delete

skip-grant-tables

6. Restart the Mysql server. At this time, the password of user root becomes root

The above is the detailed content of Share the solution to solve the problem of forgotten password in Mysql5.7.17 (picture). For more information, please follow other related articles on the PHP Chinese website!