MYSQL5.6/5.7 数据库密码丢失问题处理(需重启)
文章结构图: 一、MYSQL5.6密码丢失1.? 强行停止MYSQL
2. 跳过权限启动数据库
3. 修改ROOT用户密码
<p class="1">修改密码: <p class="1">update mysql.user set password=PASSWORD('mysql01') where User='root'; --5.6修改语句 <p class="1">update mysql.user set authentication_string=password('mysql01') where user='root';? --5.7修改语句 <p class="1">flush privileges; <p class="1">? <img src="https://www.52php.cn/res/2019/01-18/19/1be37fe193b7beb8deda77c651eae7b0.png" alt=""> 4. 重启数据库测试
<p class="1">正常启动数据库: <p class="1">/usr/local/mysql5.6/bin/mysqld_safe --defaults-file=/etc/my3306.cnf & <p class="1">? <img src="https://www.52php.cn/res/2019/01-18/19/df12ac4527a51b211e223bc93e7d8bad.png" alt=""> <p class="1">测试登陆: <p class="1">? <img src="https://www.52php.cn/res/2019/01-18/19/d18d0d248a468519a5dbbfe6f57d55ff.png" alt=""> <p class="1">修改成功。 <p class="1">? 二、MYSQL5.7密码丢失1. 强行停止MYSQL
<p class="1">强行停止数据库: <p class="1">ps -ef |grep mysql <p class="1">kill -9 2123 3430 <p class="1">? <img src="https://www.52php.cn/res/2019/01-18/19/7bf6bbc46f104bc08a03f8fe89bbfde5.png" alt=""> <p class="1">ps -ef|grep mysql <p class="1">? <img src="https://www.52php.cn/res/2019/01-18/19/235b154bc442c21165f9a6b66b2bffa6.png" alt=""> 2. 跳过权限启动数据库
3.修改ROOT用户密码
4.重启数据库测试
<p class="1">正常启动数据库: <p class="1">/usr/local/mysql5.7/bin/mysqld_safe --defaults-file=/etc/my3307.cnf & <p class="1">? <p class="1">测试登陆: <p class="1">mysql -S /tmp/mysql3307.sock -uroot -p'mysql01' <p class="1">? <img src="https://www.52php.cn/res/2019/01-18/19/be8e803dd0468f6d52fd667a73861a01.png" alt=""> <p class="1">注意正常情况下是这样修改: <p class="1">set password for 'root'@'localhost'=password('mysql'); <p class="1">? (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |