mysql密码重置

# 停止服务
systemctl stop mysqld

# 修改my.cnf配置文件在[mysqld]板块下添加skip-grant-tables配置
[mysqld]
skip-grant-tables

# 重启mysql
systemctl start mysqld

# 登录mysql并修改密码，新密需要注意是否满足密码安全策略，不满足会提示修改错误
flush privileges;
alter user 'root'@'localhost' identified by '新密码';

# 修改完成后在my.cnf配置中移除skip-grant-tables配置，重启mysql
systemctl restart mysqld