mysql8.0.28忘记密码

# 跳过授权表验证
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
最后添加：
skip-grant-tables

# 刷新权限
FLUSH PRIVILEGES;

# 修改密码
ALTER USER 'root'@'%' IDENTIFIED WITH MYSQL_NATIVE_PASSWORD BY '密码';

# 去掉跳过授权验证
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
# 注释掉
# skip-grant-tables

# 重启
sudo systemctl restart mysql