202109010651 - mysql忘记密码

# 修改配置文件
/etc/my.cnf
[mysqld]
skip-grant-tables

# 重启
./support-files/mysql.server restart

# 修改密码
mysql -uroot -p  #直接登录

update mysql.user set authentication_string=password('123') where user='root';

flush privileges;