mysql5.7.24启动报错:ERROR 1862 (HY000): Your password has expired. To log in you must change it using a
16lz
2021-01-22
报错原因是:密码过期。不管你是刚刚修改密码还是什么,只要登陆都是有问题的,都是报这样子的错误。
解决方法是:
1、修改/etc/my.cnf文件,在[mysqld]下加入“skip-grant-tables”。
2、重启mysql服务器
3、登陆mysql
[root@:vg_adn_tidbCkhsTest /usr/local/src]#mysql -u root -p #此处直接按下enter键即可 Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.7.24 MySQL Community Server (GPL) Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MySQL [(none)]> update mysql.user set password_expired='N' where user='root' -> ; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 MySQL [(none)]> flush privileges; Query OK, 0 rows affected (0.00 sec) MySQL [(none)]> exit
更多相关文章
- org.json Android系统错误。JSONException:在字符0处输入结束
- mysql获取某个范围内的随机数,写了个存储过程自动生成随机6为密码
- Navicat连接mysql8出现1251错误
- MYSQL错误代码和消息
- mySQL错误: The used table type doesn't support FULLTEXT inde
- 使用随机盐改进密码哈希
- MySQL 主从同步Out of Memory 错误分析
- PHP解析错误:语法错误,意外的T_VARIABLE
- 阿里云服务器忘记mysql的登录密码时候如何修改密码