Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to do mysql8.0.19 forget password, has certain reference value, interested friends can refer to, I hope you have a lot of harvest after reading this article, let Xiaobian take you to understand.

MySQL 8.0.19 Support 3 wrong password entries to lock accounts (example)

1. Open cmd window (preferably as administrator), net stop mysql Stop mysql service

2. Open mysql service that skips authentication password

mysqld --console --skip-grant-tables --shared-memory

3. Open a new cmd window and start the mysql service

mysql -u root -p

4. Enter password directly Spacebar Skip

5. Leave password blank

use mysqlupdate user set authentication_string='' where user='root';exit

6. Close the mysql service opened in step 2 (just close the window)

7. Restart mysql service, you can log in without password

8. change the password

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '111111';flush privileges

Adding WITH mysql_native_password ensures that navicat connections do not go wrong

Thank you for reading this article carefully. I hope that the article "mysql8.0.19 Forget Password" shared by Xiaobian will help everyone. At the same time, I hope everyone will support you a lot. Pay attention to the industry information channel. More relevant knowledge is waiting for you to learn!

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.