设置数据库进入无密码模式
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';