mysql8忘记密码

admin

1.修改/etc/my.cnf,添加skip-grant-tables

1. [mysql]
   
2. default-character-set=utf8
   
3. [mysqld]
   
4. skip-name-resolve
   
5. port = 3306
   
6. basedir=/usr/local/mysql
   
7. datadir=/app/mysql/data
   
8. max_connections=200
   
9. character-set-server=utf8
   
10. lower_case_table_names=1
    
11. default-storage-engine=INNODB
    
12. skip-grant-tables
    

复制代码

2.启动mysql

systemctl start mysql
3.无密码登录mysql,-p提示输入密码后，直接回车进入

1. [root@vm1 etc]# mysql -uroot -p
   
2. Enter password:
   
3. Welcome to the MySQL monitor.  Commands end with ; or \g.
   
4. Your MySQL connection id is 7
   
5. Server version: 8.0.27 MySQL Community Server - GPL
   
6. 
   
7. Copyright (c) 2000, 2021, Oracle and/or its affiliates.
   
8. 
   
9. Oracle is a registered trademark of Oracle Corporation and/or its
   
10. affiliates. Other names may be trademarks of their respective
    
11. owners.
    
12. 
    
13. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
14. 
    
15. mysql> flush privileges;
    
16. Query OK, 0 rows affected (0.04 sec)
    

复制代码

4.修改密码

1. mysql> alter user 'root'@'localhost' identified with mysql_native_password by 'mysql';
   
2. Query OK, 0 rows affected (0.00 sec)
   
3. 
   
4. mysql>
   
5. mysql>
   
6. mysql>
   
7. mysql> flush privileges;
   
8. Query OK, 0 rows affected (0.01 sec)

复制代码

5.关闭数据库
systemctl stop mysql
6.去掉my.cnf中的skip-grant-tables
7.启动数据库，正常密码登录