MySQL数据库root密码丢失问题

分手后的思念是犯贱 2021-12-01 13:42 329阅读 0赞

## 问题：丢失超户密码，进不去数据库： ##

\#./mysql -uroot -p  
Enter password:  
ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES)

![在这里插入图片描述][20190720165518254.png]

## 强制停掉数据库 ##

# ps -ef | grep mysql

![在这里插入图片描述][20190720165836423.png]

# kill -9 44184 43251

## 加跳过权限表参数，重启数据库 ##

*  加 --skip-grant-tables参数，可跳过权限表

# ./mysqld_safe --defaults-file=/etc/my.cnf --skip-grant-tables &
    # ./mysql		#不用密码，也能进入数据库

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDI5NzMwMw_size_16_color_FFFFFF_t_70]

## 给root用户设置新密码并刷新权限 ##

root@localhost [(none)]>use mysql;
    root@localhost [mysql]>update user set authentication_string=password('root') where user='root';
    root@localhost [mysql]>flush privileges;

*  password(‘密码’)，第一个root才是密码  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDI5NzMwMw_size_16_color_FFFFFF_t_70 1]

## 将之前的mysql进程kill掉，然后重新登陆即可 ##

# ./mysqld_safe --defaults-file=/etc/my.cnf &
    # ./mysql -uroot -proot

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDI5NzMwMw_size_16_color_FFFFFF_t_70 2]

[20190720165518254.png]: /images/20211201/f5036a645b7248b89484b88536d6e47e.png
[20190720165836423.png]: /images/20211201/b44aac061b114b66a85c80cedb3a4bb4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDI5NzMwMw_size_16_color_FFFFFF_t_70]: /images/20211201/33404e8115ce467ea14fdd5cdc4a0f03.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDI5NzMwMw_size_16_color_FFFFFF_t_70 1]: /images/20211201/04eef0921aff4090b9a1288c83ea3bc5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDI5NzMwMw_size_16_color_FFFFFF_t_70 2]: /images/20211201/032a8898953840f1b59371630f8c720f.png