Mysql 5.7.17 What should I do if I forget my password? mysql5.7.17
1. Add the skip-grant-tables in the my. ini file and restart the MySQL server.
2. Access cmd as an administrator or use database management tools. Here I use navicat to connect to the database.
Enter the connection name and password. Click OK.
3. Double-click mysql database and click query in the menu bar to create a query.
4. ExecuteUpdate user set authentication_string = password ('root') where user = 'root'
5. Comment out or delete the file in my. ini.Skip-grant-tables
6. Restart the Mysql server. At this time, the user's root Password becomes root.
For mysql topics provided by this site, you can refer:
Install Mysql in various systems
Mysql Root Password Operation Skills
MySql database getting started tutorial
Database Operation Knowledge in MySQL
The above is a small Editor to introduce you to Mysql 5.7.17 forgot the password, I hope to help you, if you have any questions, please leave a message, the small editor will reply to you in a timely manner. Thank you very much for your support for the help House website!