Mysql 5.7忘记密码后，修改密码的方式

1、修改配置文件my.cnf 按i编辑

[root@centos7 ~]# vim /etc/my.cnf

在[mysqld]中添加

skip-grant-tables

2、重启mysql服务

systemctl restart mysqld

3、用户登录

mysql -uroot -p (直接点击回车，密码为空)

4.修改密码

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> alter user root@'localhost' identified by 'MyNewPass4!';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> status
--------------
mysql  Ver 14.14 Distrib 5.7.34, for Linux (x86_64) using  EditLine wrapper

Connection id:		4
Current database:	
Current user:		root@localhost
SSL:			Not in use
Current pager:		stdout
Using outfile:		''
Using delimiter:	;
Server version:		5.7.34 MySQL Community Server (GPL)
Protocol version:	10
Connection:		Localhost via UNIX socket
Server characterset:	latin1
Db     characterset:	latin1
Client characterset:	utf8
Conn.  characterset:	utf8
UNIX socket:		/var/lib/mysql/mysql.sock
Uptime:			23 min 7 sec

Threads: 1  Questions: 11  Slow queries: 0  Opens: 106  Flush tables: 1  Open tables: 99  Queries per secovg: 0.007
--------------

mysql> exit