CentOS MySQL8 忘记密码

设置数据库进入无密码模式

systemctl stop mysqld
systemctl set-environment MYSQLD_OPTS="--skip-grant-tables"
systemctl start mysqld
mysqld -uroot

修改密码

update mysql.user set authentication_string='' where user='root';

设置密码模式

systemctl stop mysqld
systemctl unset-environment MYSQLD_OPTS
systemctl start mysqld

重新设置密码

alter user root@localhost identified by 'Xxxxx@123';