Mysql 5.7what if I forget my root password

This article mainly explains "mysql 5.7forget root password how to do", the article explains the content is simple and clear, easy to learn and understand, now please follow the editor's train of thought slowly in depth, together to study and learn "mysql 5.7forget root password how to do" it!

A test library created temporarily, forgetting the root password, can be solved by the following methods:

1. Add skip-grant-tables=1 under [mysqld] by editing / etc/my.cnf file to save and exit

[mysqld] skip-grant-tables=1

2. Restart the MySql service

[root@iZ2ze7qh7q0di3qkvef1dzZ etc] # systemctl stop mysqld.service [root@iZ2ze7qh7q0di3qkvef1dzZ etc] # systemctl start mysqld.service

Log in to mysql as root

[root@iZ2ze7qh7q0di3qkvef1dzZ etc] # mysql-u rootWelcome to the MySQL monitor. Commands end with; or\ g.Your MySQL connection id is 2Server version: 5.7.24 MySQL Community Server (GPL) Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or'\ h' for help. Type'\ c'to clear the current input statement.

4. Access the mysql database

Mysql > use mysqlReading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with-ADatabase changed

5. Modify the root password:

Mysql > update user set authentication_string = password ('HecomDB2015roommates'), password_last_changed=now () where user='root';Query OK, 2 rows affected, 1 warning (0.00 sec) Rows matched: 2 Changed: 2 Warnings: 1

6. Exit mysql, edit the / etc/my.cnf file again, delete the skip-grant-tables=1 added in the first step, and restart the MySql service.

Thank you for reading, the above is "mysql 5.7forget root password how to do" the content, after the study of this article, I believe you on mysql 5.7forget root password how to do this problem has a deeper understanding, the specific use of the situation also needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!