1、打开/etc/mysql/my.cnf,在[mysqld]中加入skip-grant-tables,然后使用service mysql restart
重启mysql服务,即可无密码用root登录数据库
[mysqld]
skip-grant-tables
2、切换数据到mysql
use mysql;
3、更新root密码
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'mysql';
4、如果更新root密码时报The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
,执行下面语句刷新下权限,然后再执行更新密码即可。
flush privileges;