Shulou(Shulou.com)06/01 Report--

1. Skip database permission verification

Mysqld-skip-grant-tables-user=mysql &

two,

Systemctl restart mysqld

Normally, you can't get up and wait for ctrl + c to stop in about 10 seconds.

3. Enter mysql to enter

4. Change the new password

UPDATE mysql.user SET authentication_string=password ('new_password') WHERE user='root' AND host='localhost'

5, refresh the authorization table

FLUSH PRIVILEGES; refresh authorization table

6 exit exit from the database and log in with the new password to log in successfully

7. It is best to restart reboot to make mysql running.

Note: error handling

Problem 1:ERROR You must reset your password using ALTER USER statement before executing this statement

Solution: ALTER USER 'root'@'localhost' IDENTIFIED BY' xinmima'

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.