mysql重置root密码

最新推荐文章于 2021-12-25 21:59:35 发布

风杀

最新推荐文章于 2021-12-25 21:59:35 发布

阅读量420

点赞数

CC 4.0 BY-SA版权

文章标签： mysql 修改密码忘记密码重置密码数据库重置密码

本文链接：https://blog.youkuaiyun.com/IfengshaI/article/details/88581275

本文详细介绍了在CentOS7系统中，使用MySQL5.7版本时如何跳过密码验证，无密码进入MySQL命令框，并重置root用户密码的全过程。包括修改配置文件my.cnf，重启mysqld服务，执行SQL语句删除旧密码记录，插入新密码，更新用户权限等关键步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

亲测环境：centos7+mysql5.7

跳过密码验证
vi /etc/my.cnf
[mysqld]
skip-grant-tables

重启mysqld
systemctl restart mysqld

无密码进入mysql命令框
mysql -uroot

进入mysql数据库
use mysql;

修改root密码为root(*81F5E21E35407D884A6CD4A731AEBFB6AF209E1B)为设置密码root
delete from user where user = ‘root’;
INSERT INTO user VALUES (‘localhost’, ‘root’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘’, ‘’, ‘’, ‘’, 0, 0, 0, 0, ‘mysql_native_password’, ‘*81F5E21E35407D884A6CD4A731AEBFB6AF209E1B’, ‘N’, ‘2018-12-10 13:21:57’, NULL, ‘N’);
update user set host = ‘%’ where user = ‘root’;
update user set account_locked=“N” where user=“root” or Host=“localhost” or host=“127.0.0.1”;

关闭跳过密码验证
vi /etc/my.cnf
[mysqld]
#skip-grant-tables

重启mysqld
systemctl restart mysqld
mysql -u root -p
root