欢迎来访下代码，网站建设及模板提供商！
微信
在线客服QQ:644080923
收藏本站
帮助中心
关于我们
热搜：
代码授权
网站模板
客户案例
服务中心
建站教程
所有产品分类
网站模板
新闻资讯
博客媒体
图库图片
网络公司
信息科技
科技产品
客户案例
企业官网
综合门户
新闻媒体
购物商城
服务中心
系统部署
宝塔部署
证书安装
ICP备案
网站首页
网站模板
新闻资讯
博客媒体
图库图片
网络公司
信息科技
科技产品
客户案例
企业官网
综合门户
新闻媒体
购物商城
服务中心
系统部署
宝塔部署
证书安装
ICP备案
更多
建站教程
cms教程
cms文档
服务器教程
数据库教程
资源下载
您现在的位置：
网站首页
>
服务器教程
>
在Linux环境下mysql的root密码忘记解决方法
发布时间：2022-10-27
热度： ℃
<p><span style="color: rgb(77, 77, 77); font-family: -apple-system, " sf="" ui="" pingfang="" hiragino="" sans="" microsoft="" wenquanyi="" micro="" font-variant-ligatures:="" background-color:="">mysql版本不同，修改密码的方法大同小异，但是有一定的区别：</span></p><p><span style="color: rgb(77, 77, 77); font-family: -apple-system, " sf="" ui="" pingfang="" hiragino="" sans="" microsoft="" wenquanyi="" micro="" font-variant-ligatures:="" background-color:=""><br/></span></p><p><span style="color: rgb(77, 77, 77); font-family: -apple-system, " sf="" ui="" pingfang="" hiragino="" sans="" microsoft="" wenquanyi="" micro="" font-variant-ligatures:="" background-color:=""></span></p><p style="box-sizing: border-box; outline: 0px; margin-top: 0px; margin-bottom: 16px; padding: 0px; color: rgb(77, 77, 77); line-height: 26px; overflow: auto hidden; overflow-wrap: break-word; font-family: -apple-system, " sf="" ui="" pingfang="" hiragino="" sans="" microsoft="" wenquanyi="" micro="" font-variant-ligatures:="" white-space:="" background-color:="">mysql5.6及以下</p><p style="box-sizing: border-box; outline: 0px; margin-top: 0px; margin-bottom: 16px; padding: 0px; color: rgb(77, 77, 77); line-height: 26px; overflow: auto hidden; overflow-wrap: break-word; font-family: -apple-system, " sf="" ui="" pingfang="" hiragino="" sans="" microsoft="" wenquanyi="" micro="" font-variant-ligatures:="" white-space:="" background-color:="">1、修改MySQL的登录设置：<br/></p><h1 style="box-sizing: border-box; outline: 0px; margin: 8px 0px 16px; padding: 0px; font-family: " pingfang="" microsoft="" font-size:="" color:="" line-height:="" overflow-wrap:="" font-variant-ligatures:="" white-space:="" background-color:="">vi /etc/my.cnf</h1><p style="box-sizing: border-box; outline: 0px; margin-top: 0px; margin-bottom: 16px; padding: 0px; color: rgb(77, 77, 77); line-height: 26px; overflow: auto hidden; overflow-wrap: break-word; font-family: -apple-system, " sf="" ui="" pingfang="" hiragino="" sans="" microsoft="" wenquanyi="" micro="" font-variant-ligatures:="" white-space:="" background-color:="">在[mysqld]的段中加上一句：skip-grant-tables 保存并且退出</p><p style="box-sizing: border-box; outline: 0px; margin-top: 0px; margin-bottom: 16px; padding: 0px; color: rgb(77, 77, 77); line-height: 26px; overflow: auto hidden; overflow-wrap: break-word; font-family: -apple-system, " sf="" ui="" pingfang="" hiragino="" sans="" microsoft="" wenquanyi="" micro="" font-variant-ligatures:="" white-space:="" background-color:="">2．重新启动mysqld service mysqld restart</p><p style="box-sizing: border-box; outline: 0px; margin-top: 0px; margin-bottom: 16px; padding: 0px; color: rgb(77, 77, 77); line-height: 26px; overflow: auto hidden; overflow-wrap: break-word; font-family: -apple-system, " sf="" ui="" pingfang="" hiragino="" sans="" microsoft="" wenquanyi="" micro="" font-variant-ligatures:="" white-space:="" background-color:="">3．登录并修改MySQL的root密码</p><p style="box-sizing: border-box; outline: 0px; margin-top: 0px; margin-bottom: 16px; padding: 0px; color: rgb(77, 77, 77); line-height: 26px; overflow: auto hidden; overflow-wrap: break-word; font-family: -apple-system, " sf="" ui="" pingfang="" hiragino="" sans="" microsoft="" wenquanyi="" micro="" font-variant-ligatures:="" white-space:="" background-color:="">mysql> USE mysql ;<br style="box-sizing: border-box; outline: 0px; overflow-wrap: break-word;"/>mysql> UPDATE user SET Password = password ( ‘new-password’ ) WHERE User = ‘root’ ;<br style="box-sizing: border-box; outline: 0px; overflow-wrap: break-word;"/>mysql> flush privileges ;<br style="box-sizing: border-box; outline: 0px; overflow-wrap: break-word;"/>mysql> quit</p><p style="box-sizing: border-box; outline: 0px; margin-top: 0px; margin-bottom: 16px; padding: 0px; color: rgb(77, 77, 77); line-height: 26px; overflow: auto hidden; overflow-wrap: break-word; font-family: -apple-system, " sf="" ui="" pingfang="" hiragino="" sans="" microsoft="" wenquanyi="" micro="" font-variant-ligatures:="" white-space:="" background-color:="">4．将MySQL的登录设置修改回来</p><h1 style="box-sizing: border-box; outline: 0px; margin: 8px 0px 16px; padding: 0px; font-family: " pingfang="" microsoft="" font-size:="" color:="" line-height:="" overflow-wrap:="" font-variant-ligatures:="" white-space:="" background-color:="">vi /etc/my.cnf</h1><p style="box-sizing: border-box; outline: 0px; margin-top: 0px; margin-bottom: 16px; padding: 0px; color: rgb(77, 77, 77); line-height: 26px; overflow: auto hidden; overflow-wrap: break-word; font-family: -apple-system, " sf="" ui="" pingfang="" hiragino="" sans="" microsoft="" wenquanyi="" micro="" font-variant-ligatures:="" white-space:="" background-color:="">将刚才在[mysqld]的段中加上的skip-grant-tables删除</p><p style="box-sizing: border-box; outline: 0px; margin-top: 0px; margin-bottom: 16px; padding: 0px; color: rgb(77, 77, 77); line-height: 26px; overflow: auto hidden; overflow-wrap: break-word; font-family: -apple-system, " sf="" ui="" pingfang="" hiragino="" sans="" microsoft="" wenquanyi="" micro="" font-variant-ligatures:="" white-space:="" background-color:="">5．重新启动mysqld</p><h1 style="box-sizing: border-box; outline: 0px; margin: 8px 0px 16px; padding: 0px; font-family: " pingfang="" microsoft="" font-size:="" color:="" line-height:="" overflow-wrap:="" font-variant-ligatures:="" white-space:="" background-color:="">/etc/init.d/mysqld restart ( service mysqld restart )</h1><p><span style="color: rgb(77, 77, 77); font-family: -apple-system, " sf="" ui="" pingfang="" hiragino="" sans="" microsoft="" wenquanyi="" micro="" font-variant-ligatures:="" background-color:=""><br/></span></p><p><span style="color: rgb(77, 77, 77); font-family: -apple-system, " sf="" ui="" pingfang="" hiragino="" sans="" microsoft="" wenquanyi="" micro="" font-variant-ligatures:="" background-color:=""></span></p><p style="box-sizing: border-box; outline: 0px; margin-top: 0px; margin-bottom: 16px; padding: 0px; color: rgb(77, 77, 77); line-height: 26px; overflow: auto hidden; overflow-wrap: break-word; font-family: -apple-system, " sf="" ui="" pingfang="" hiragino="" sans="" microsoft="" wenquanyi="" micro="" font-variant-ligatures:="" white-space:="" background-color:="">mysql5.7：</p><p style="box-sizing: border-box; outline: 0px; margin-top: 0px; margin-bottom: 16px; padding: 0px; color: rgb(77, 77, 77); line-height: 26px; overflow: auto hidden; overflow-wrap: break-word; font-family: -apple-system, " sf="" ui="" pingfang="" hiragino="" sans="" microsoft="" wenquanyi="" micro="" font-variant-ligatures:="" white-space:="" background-color:=""><br style="box-sizing: border-box; outline: 0px; overflow-wrap: break-word;"/>1.停掉数据库： service mysql stop<br style="box-sizing: border-box; outline: 0px; overflow-wrap: break-word;"/>2.运行：# mysqld_safe --skip-grant-tables &<br style="box-sizing: border-box; outline: 0px; overflow-wrap: break-word;"/>3.登陆数据库： mysql -p</p><p style="box-sizing: border-box; outline: 0px; margin-top: 0px; margin-bottom: 16px; padding: 0px; color: rgb(77, 77, 77); line-height: 26px; overflow: auto hidden; overflow-wrap: break-word; font-family: -apple-system, " sf="" ui="" pingfang="" hiragino="" sans="" microsoft="" wenquanyi="" micro="" font-variant-ligatures:="" white-space:="" background-color:="">4.更改密码： mysql> update mysql.user set authentication_string=password(‘123qwe’) where user=‘root’ and Host = ‘localhost’;<br style="box-sizing: border-box; outline: 0px; overflow-wrap: break-word;"/>不过这里要提示一下：新版本的数据库下的user表里面已经没有password了<br style="box-sizing: border-box; outline: 0px; overflow-wrap: break-word;"/>而是将加密后的用户密码存储在authentication_string字段下面<br style="box-sizing: border-box; outline: 0px; overflow-wrap: break-word;"/>flush privileges;<br style="box-sizing: border-box; outline: 0px; overflow-wrap: break-word;"/>quit<br style="box-sizing: border-box; outline: 0px; overflow-wrap: break-word;"/>5. 重启下mysql ： service mysql restart</p><p style="box-sizing: border-box; outline: 0px; margin-top: 0px; margin-bottom: 16px; padding: 0px; color: rgb(77, 77, 77); line-height: 26px; overflow: auto hidden; overflow-wrap: break-word; font-family: -apple-system, " sf="" ui="" pingfang="" hiragino="" sans="" microsoft="" wenquanyi="" micro="" font-variant-ligatures:="" white-space:="" background-color:="">但此时操作似乎功能不完全，还要alter user…</p><p style="box-sizing: border-box; outline: 0px; margin-top: 0px; margin-bottom: 16px; padding: 0px; color: rgb(77, 77, 77); line-height: 26px; overflow: auto hidden; overflow-wrap: break-word; font-family: -apple-system, " sf="" ui="" pingfang="" hiragino="" sans="" microsoft="" wenquanyi="" micro="" font-variant-ligatures:="" white-space:="" background-color:="">mysql> alter user ‘root’@localhost’ identified by ‘123456’</p><p><span style="color: rgb(77, 77, 77); font-family: -apple-system, " sf="" ui="" pingfang="" hiragino="" sans="" microsoft="" wenquanyi="" micro="" font-variant-ligatures:="" background-color:=""><br/></span><br/></p>
上一篇：
nginx实现https网站设
下一篇：
Tomcat安装SSL证书-阿
相关阅读
linux scp命令并指定端口
宝塔部署Java系统(不与PHP冲突)
此网站无法提供安全连接(客户端和服务器不支持一般 SSL 协议版本或加密套件。)--TLS 1.1/TLS 1.2配置
linux 安装jdk 8u351
linux 安装mysql 5.7.38
linux查询端口号对应的服务名
Docker安装Mysql5.7
windows电脑开启Telnet
QQ在线咨询
售前客服
微信客服
工作日 9:00-18:00
