1.登入mysql数据库
若忘记登陆密码,则编辑配置文件mysqld.cnf
sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
在[mysqld]下面添加skip-grant-tables
[mysqld]
skip-grant-tables
* Basic Settings
保存退出,重启mysql服务
sudo service mysql restart
直接输入mysql登陆
zhi@zhi:~$ mysql
2.重置root密码
use mysql;
update user set authentication_string=PASSWORD(“xxx”) where User=‘root’;
update user set plugin=“mysql_native_password” where User=‘root’; # THIS LINE
flush privileges;