前言: 之前安装了mysql,但是忘记密码,So,百度了解决方案,发现很多答案的代码执行都报错,最后终于找到一个可行的了。
不可行代码:
1.set password for root@localhost = password('123');
2.mysqladmin -uroot -p123456 password 123
3.update user set password=password('123') where user='root' and host='localhost';
可行代码:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'newpassword';
执行步骤:
一.先跳过登陆进入mysql
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
在末尾加入代码,保存退出
skip-grant-tables
重启mysql:
service mysql restart
不用输入密码直接进入mysql
mysql -uroot -p
二.执行以下mysql命令:
flush privileges;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的密码';
flush privileges;
exit; #退出
进入配置注释 skip-grant-tables
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
# skip-grant-tables
重启mysql:
service mysql restart
参考文章:
https://blog.csdn.net/sinat_36171694/article/details/89481731
https://www.cnblogs.com/mzxiaoze/p/10413399.html