How to reset the root password in Linux mysql-5.6

1. Check whether the MySQL service is started. If it is started, shut down the MySQL service.

Run the command: ps -ef | grep -i mysql

If it is open, run the shutdown command: service mysqld stop

2. Modify the mysql configuration file my.conf

Generally, in the /etc directory, run the command: vi /etc/my.cnf to edit the file

Add a sentence under the [mysqld] tag in the file: skip-grant-tables

Then press wq! to save and exit.

3. Restart the database

Run the command: service mysqld start

4. Restart the database

Run the command: service mysqld start

5. Enter the mysql database

Run the command: mysql -u root

6. Enter the mysql database

Run the command: mysql -u root

7. Change password

Here is how 5.6 does it

Run statement: use mysql;
Continue to run the statement: update mysql.user set password=password('root_password') where user='root';
Replace root_password with your desired password

Here is how 5.7 does it

Run statement: use mysql;
Continue to run the statement: update mysql.user set authentication_string=password('root_password') where user='root';
Replace root_password with your desired password

8. Delete what was added in step 2, restart the server, and then you can log in to the server using the password you just changed.

mysql -u root -p

At this point, everything is finished.

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.