1.编辑mysqld.cnf文件
sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
2.在文件中的skip-external-locking一行的下面添加一行:
skip-grant-tables
3.重启MySQL服务
sudo service mysql restart
4.终端输入mysql进入MySQL,输入USE mysql切换至mysql数据库
mysql
USE mysql
5.把root用户的密码修改为新密码,我这里是000000
UPDATE mysql.user SET authentication_string=password('000000') WHERE User='root' AND Host ='localhost';
6.修改字段plugin
UPDATE user SET plugin="mysql_native_password";
7.刷新系统权限相关表
flush privileges;
8.退出
quit;
9.注释掉/etc/mysql/mysql.conf.d/mysqld.cnf文件中添加的一行
10.重启MySQL服务
sudo service mysql restart
11.重新登陆,然后输入密码进去
mysql -u root -p