成功安装了MySQL后,忘记密码该如何解决?
1.修改/etc/my.cnf配置文件,加入skip–grant-tables后正常登陆
2.挖坑环节,MySQL8.0以上先修改密码的策略不一样,之前按8.0之前的版本,一直出错。才意识到是版本问题。
3.重新操作一遍:
#vim /etc/my.cnf
【mysql】
添加skip-grant-table
#systemctl restart mysqld
#mysql –u root
[敲回车进入]
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> alter user ‘root’@'localhost’IDENTIFIED BY ‘MyNewPass’;
ERROR 1819 (HY000): Your password does notsatisfy the current policy requirements
mysql> alter user ‘root’@'localhost’IDENTIFIED BY ‘MyNewPass@123’;
ERROR 1396 (HY000): Operation ALTER USERfailed for ‘root’@‘localhost’