一、修改配置文件:
mysqld:
skip-grant-tables
跳过验证
二、修改命令:
select * from mysql.`user`;
use mysql;
update mysql.`user` set authentication_string = password('000000') where `User`='user';
update user set plugin="mysql_native_password";
flush PRIVILEGES;
三、重新登录
mysql -uroot -p000000