记一次重置mysql8密码的操作

1. 停止服务

service mysqld stop or systemctl stop mysqld.service

2. 启动服务，不检查授权表

mysqld --skip-grant-tables --skip-networking &

报错：
sock 权限问题

sudo chown -R mysql:mysql /var/lib/mysql/

3. 执行重置

alter user 'root'@'localhost' IDENTIFIED BY '123456';
create user 'root'@'localhost' identified by '123456';

都失败
Operation ALTER USER failed for ‘root‘@’localhost’
Operation CREATE USER failed for ‘root‘@’localhost’

先执行flush privileges

仍然失败，可能是因为用户已经被删除了，再删除一次
drop user ‘root‘@’localhost’;
create user ‘root‘@’localhost’ identified by ‘123456’;
提示密码不符合规则

SHOW VARIABLES LIKE 'validate_password%';

set global validate_password.policy=0;
set global validate_password.length=6;

4. flush 一下

flush privileges

5. 重启

service mysqld restart