Home >Database >Mysql Tutorial >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
mysql database, click the menu bar Query, and create a new query
update user set authentication_string = password('root') where user = 'root'
skip-grant-tables
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!