Linux MySQL 8.0 Forgot password

Do not forget the MySQL password, in accordance with the book and the content of the Internet has not been able to modify the success, finally, after drawing on the success of a number of articles to find reasons, change the password success, hereby share

Modify MySQL Password

• First step: Close the MySQL process

systemctl stop mysqldservice mysqld stop/etc/init.d/mysql stopkill PID#以选一个方法即可

• Step Two: Configure/ETC/MY.CNF skip Permission table Authentication Direct Login

# 在【mysqld】模块添加：skip-grant-tables   保存退出[mysqld]skip-grant-table

• Step three: Restart the MySQL service and log into

systemctl start mysqldservice mysqld start/etc/init.d/mysql start#以上选一个方法即可

• Fourth step: Refresh the Permissions table, so that the permission authentication re-entry into force

flush privileges

Note: Many articles on the Internet do not have this step, this is not correct, will be error, such as:

Correct should be as (the new MySQL password needs to be set to a complex number of at least 8 bits):

• Finally: Don't forget to change the/etc/my.cnf back and restart

Linux MySQL 8.0 Forgot password