快捷導航

linux mysql8忘記密碼的解決方案

更新時間：2026年04月17日 09:37:02 作者：搬磚的夢先生

本文介紹了兩種MySQL重置密碼的方法：一是關(guān)閉登錄驗證重置密碼,二是開啟登錄驗證后重置密碼,前者需要修改my.cnf配置文件并添加skip-grant-tables,后者則需刪除此配置并直接輸入新密碼

1、關(guān)閉mysql登錄驗證

停止mysql

$ systemctl stop mysqld.service

修改/etc/my.cnf,跳過權(quán)限驗證

在my.cnf 下面添加

skip-grant-tables

啟動mysql

$ systemctl start mysqld.service

2、重置mysql密碼

重置root密碼為空

update user set authentication_string='' where user='root';

查看root密碼是否為空

select user, authentication_string from mysql.user;

保存修改

flush privileges;

示例如下：

$ mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 8.0.32 Source distribution

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

mysql> update user set authentication_string='' where user='root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select user, authentication_string from mysql.user;
+------------------+------------------------------------------------------------------------+
| user             | authentication_string                                                  |
+------------------+------------------------------------------------------------------------+
| root             |                                                                        |
| mysql.infoschema | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| mysql.session    | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| mysql.sys        | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
+------------------+------------------------------------------------------------------------+
6 rows in set (0.01 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> \q
Bye

3、開啟mysql登錄驗證

停止mysql

$ systemctl stop mysqld.service

修改/etc/my.cnf,把my.cnf 下面添加的skip-grant-tables刪除

啟動mysql

$ systemctl start mysqld.service

4、修改mysql密碼

使用下面命令登錄，在輸入密碼的那一步直接回車

$ mysql -uroot -p

修改root密碼

‘root’@‘%’: root可以允許任務(wù)機器連接

alter user 'root'@'%' identified by '你的密碼';

查看root密碼

select user, authentication_string from mysql.user;

保存修改

flush privileges;

示例如下：

$ mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.32 Source distribution

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> alter user 'root'@'%' identified by 'mysql.root_2023';
Query OK, 0 rows affected (0.00 sec)

mysql> select user, authentication_string from mysql.user;
+------------------+------------------------------------------------------------------------+
| user             | authentication_string                                                  |
+------------------+------------------------------------------------------------------------+
| root             | *A780CA81542274F7A6F52BBC40B7B2E2F9BE8A0F                              |
| mysql.infoschema | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| mysql.session    | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| mysql.sys        | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
+------------------+------------------------------------------------------------------------+
6 rows in set (0.01 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> \q
Bye