在CentOS7中重置MySQL root密码

迈不过友情╰ 2023-02-15 12:37 15阅读 0赞

### 文章目录 ###

*  在CentOS7中重置MySQL root密码
 *   *  重设MySQL root密码
     *  参考文档

# 在CentOS7中重置MySQL root密码 #

## 重设MySQL root密码 ##

在MySQL 5.7.29 上验证通过。

# 停止MySQL
    sudo systemctl stop mysqld
    
    # 设置关闭鉴权和网络连接
    sudo systemctl set-environment MYSQLD_OPTS="--skip-grant-tables --skip-networking"
    
    # 启动MySQL
    sudo systemctl start mysqld
    
    # 以root账号登录MySQL，并重设密码
    mysql -uroot
    
    update mysql.user set authentication_string=PASSWORD("NewPassword") where User='root' AND Host = 'localhost';
    flush privileges;
    quit
    
    # 停止MySQL
    sudo systemctl stop mysqld
    
    # 恢复鉴权和网络连接设置
    sudo systemctl unset-environment MYSQLD_OPTS
    
    # 启动MySQL
    sudo systemctl start mysqld

运行`mysql -uroot -p`重新登录MySQL来验证新密码是否可以登录成功。

## 参考文档 ##

*  [https://fullstack-tutorials.com/mysql/reset-mysql-root-password-in-centos-7][https_fullstack-tutorials.com_mysql_reset-mysql-root-password-in-centos-7]
 *  [https://stackoverflow.com/questions/33510184/change-mysql-root-password-on-centos7][https_stackoverflow.com_questions_33510184_change-mysql-root-password-on-centos7]
 *  [https://blog.csdn.net/baidu\_39212797/article/details/103158682][https_blog.csdn.net_baidu_39212797_article_details_103158682]

[https_fullstack-tutorials.com_mysql_reset-mysql-root-password-in-centos-7]: https://fullstack-tutorials.com/mysql/reset-mysql-root-password-in-centos-7
[https_stackoverflow.com_questions_33510184_change-mysql-root-password-on-centos7]: https://stackoverflow.com/questions/33510184/change-mysql-root-password-on-centos7
[https_blog.csdn.net_baidu_39212797_article_details_103158682]: https://blog.csdn.net/baidu_39212797/article/details/103158682