mysql忘记密码了怎么办(修改密码)

Xiaoshuai_1

于 2024-07-27 17:20:09 发布

阅读量303

点赞数 4

文章标签： mysql adb 数据库

本文链接：https://blog.csdn.net/Xiaoshuai_1/article/details/140738391

版权

# systemctl stop mysqld
[root@localhost ~]# systemctl stop mysqld
[root@localhost ~]# vim /etc/my.cnf.d/mysql-server.cnf 
[mysqld]
skip-grant-tables
skip-networking 

[root@localhost ~]# systemctl restart mysqld
[root@localhost ~]# mysql 
mysql> USE mysql;
mysql> update user set authentication_string='' where user='root';--将字段authentication_string置为空
mysql> FLUSH PRIVILEGES;
mysql> ALTER user 'root'@'localhost' IDENTIFIED BY 'Qq111111.';--修改密码为123456
mysql> \q
Bye
[root@localhost ~]# systemctl restart mysqld