linux之解决mysql忘记root用户登录密码

水深无声 2022-04-11 08:22 474阅读 0赞

很多时候长时间不登陆mysql，再次登陆，忘记root密码，解决办法如下：

问题描述如下：

![20181205105100609.png][]

# 1、针对mysql5.6.x版本 #

1）停止mysql服务：systemctl stop mysql.service

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dzcV96cWZs_size_16_color_FFFFFF_t_70][]

2）vim /etc/my.cnf：在该文件中添加如下代码：skip-grant-tables，保存退出

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dzcV96cWZs_size_16_color_FFFFFF_t_70 1][]

3）重启mysql服务：systemctl start mysql.service

![20181205105940795.png][]

4）使用无密码登陆mysql：mysql -u root 回车

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dzcV96cWZs_size_16_color_FFFFFF_t_70 2][]

5）重置root密码：

mysql>use mysql；

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dzcV96cWZs_size_16_color_FFFFFF_t_70 3][]

mysql>update user set Password=PASSWORD('new-password') where user='root';

mysql>flush privileges;

mysql>exit;

update user set Password=PASSWORD('new-password') where user='root';
    flush privileges;
    exit;

6) vim /etc/my.cnf：注释：skip-grant-tables，保存退出

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dzcV96cWZs_size_16_color_FFFFFF_t_70 4][]

7）重启mysql服务：systemctl restart mysql.service

8）使用新设置的密码登陆mysql：mysql -u root -p 'newpassword'

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dzcV96cWZs_size_16_color_FFFFFF_t_70 5][]

# 2、针对mysql5.7.x版本 #

只有上述的第5步中重置root登陆密码的命令不同，其余操作相同，命令如下：

mysql>update mysql.user set authentication\_string=password('123456') where user='root' ;

如此便可重置忘记的root密码

[20181205105100609.png]: /images/20220411/14f8db922aa740b2bd6a4e50a7fea2ec.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dzcV96cWZs_size_16_color_FFFFFF_t_70]: /images/20220411/839156206fd34d149acc622484b7832f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dzcV96cWZs_size_16_color_FFFFFF_t_70 1]: /images/20220411/ec1ac8315ba14def94581e14672f5db7.png
[20181205105940795.png]: /images/20220411/1588d207fdec4bb7abefeaf9f727b48b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dzcV96cWZs_size_16_color_FFFFFF_t_70 2]: /images/20220411/7fc98f2ed49f4d3c8a9303e8e68e038c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dzcV96cWZs_size_16_color_FFFFFF_t_70 3]: /images/20220411/ae84e16c81014ca48aa76a14db408153.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dzcV96cWZs_size_16_color_FFFFFF_t_70 4]: /images/20220411/f47458a06e81490e96a59d217d4b7325.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dzcV96cWZs_size_16_color_FFFFFF_t_70 5]: /images/20220411/3c16b7454d204b598dbc353ff31e6046.png