关于更改mysql的root密码:
- 找到
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
添加
skip-grant-tables=1
- 保存更新
systemctl restart mysql.service
- mysql进入
- USE mysql;
- 输入ALTER user 'root'@'localhost' IDENTIFIED BY '你要改的密码';
- 如果出现
ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'localhost'
输入
FLUSH PRIVILEGES;
- 如果出现
ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'localhost'
可能是密码长度不够,我当时是123改成了12345
- exit退出
- sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
删除添加的那行
skip-grant-tables=1
重启
systemctl restart mysql.service
- mysql -u root -p
- 输入新密码就可以啦!