mysql忘记密码跳过密码登录

2021-04-04

mysql忘记密码跳过密码登录

解决方法在my.cnf中[mysqld]添加配置项

[mysqld]
skip-grant-tables

修改root密码

mysql -r root #进入mysql命令行
use mysql;
update user set password = password('newpass') where user = 'root';
flush privileges;