Problem of retrieving root password in MYSQL 5.7 under Linux (tested and available)

1. Retrieve via --skip-grant-tables

(Note: This operation must take security factors into consideration, because the database is not password protected during the period of setting password-free login)

1.1 Modify my.conf and add a new password-free login startup item

vi /etc/my.cnf

Add skip-grant-tables in the [mysqld] area

After the addition is complete, press :wq to save and exit, and restart the mysqld service.

systemctl restart mysqld

1.2 Enter the MySQL console in password-free mode and reset the password

mysql -uroot -p

When entering the password, just press Enter.

Select database mysql

use mysql;

Execute the modify root command

UPDATE user SET authentication_string = password ('Your password. The default password rule requires a combination of uppercase and lowercase letters, symbols, and numbers') WHERE User = 'root';

After successful execution, exit the MySQL database

exit;

1.3 Comment or delete the password-free login configuration item, restart the mysqld service and perform login verification

vi /etc/my.cnf

Restart the mysqld service

systemctl restart mysqld

Log in with new password for verification

mysql -uroot -p

Enter the password and press Enter to submit and verify.

This is the end of this article about retrieving the root password of MYSQL 5.7 under Linux (tested and available). For more information about retrieving the root password of MYSQL 5.7, please search the previous articles of 123WORDPRESS.COM or continue to browse the related articles below. I hope you will support 123WORDPRESS.COM in the future!