MySQL忘记密码重置方法

淩亂°似流年 2022-10-12 01:29 22阅读 0赞

# MySQL忘记密码重置方法 #

> 1、此次测试系统环境为centos7，MySQL版本为5.7.33

> 2、此方法可以作为初始安装MySQL后临时密码无法登录系统或者忘记密码情况的解决方案

> 3、停止服务并查看服务状态  
> \#systemctl stop mysqld  
> \#systemctl status mysqld  
> ![在这里插入图片描述][20210702164747852.jpg_pic_center]

> 4、打开MySQL配置文件，在\[mysqld\]节点下加skip-grant-tables  
> \#vi /etc/my.cnf

# For advice on how to change settings please see
    # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
    
    [mysqld]
    #
    # Remove leading # and set to the amount of RAM for the most important data
    # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
    # innodb_buffer_pool_size = 128M
    #
    # Remove leading # to turn on a very important data integrity option: logging
    # changes to the binary log between backups.
    # log_bin
    #
    # Remove leading # to set options mainly useful for reporting servers.
    # The server defaults are faster for transactions and fast SELECTs.
    # Adjust sizes as needed, experiment to find the optimal values.
    # join_buffer_size = 128M
    # sort_buffer_size = 2M
    # read_rnd_buffer_size = 2M
    
    skip-grant-tables
    
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    
    # Disabling symbolic-links is recommended to prevent assorted security risks
    symbolic-links=0
    
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid

> 5、启动服务(查看服务状态)并登录MySQL  
> \#systemctl start mysqld  
> \#systemctl status mysqld  
> ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjgzMTQ3Nw_size_16_color_FFFFFF_t_70_pic_center]  
> 登录MySQL,不需要密码参数  
> \#mysql -uroot  
> ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjgzMTQ3Nw_size_16_color_FFFFFF_t_70_pic_center 1]

> 6、修改密码，使用password(‘需要修改的密码’)进行更改密码  
> update user set authentication\_string=password(‘root’) where user=‘root’;  
> ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjgzMTQ3Nw_size_16_color_FFFFFF_t_70_pic_center 2]

> 7、停服务，配置文件中注释掉skip-grant-tables，启服务。使用新的密码登录MySQL。

> 小尾巴~~  
> 只要有积累，就会有进步

[20210702164747852.jpg_pic_center]: /images/20221005/b45289daf60b49b996d0cc9ed31ffc30.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjgzMTQ3Nw_size_16_color_FFFFFF_t_70_pic_center]: /images/20221005/0caf90bbbc9b4ba586645a7cb2349f6c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjgzMTQ3Nw_size_16_color_FFFFFF_t_70_pic_center 1]: /images/20221005/64f3efc9b8cc447d8c80700226a0dfdf.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjgzMTQ3Nw_size_16_color_FFFFFF_t_70_pic_center 2]: /images/20221005/95d563b79098454aab7088dacd7980c9.png