mysql5.7初始化后连接mysql的时候报:Your password has expired.
来源:互联网 发布:淘宝特种经营许可申请 编辑:程序博客网 时间:2024/05/16 19:16
mysql5.7初始化后连接mysql的时候报:
ERROR 1862 (HY000): Your password has expired. To log in you must chang
意思很明确密码过期了,但是奇怪的,我其他两个实例都没这个问题,挺诡异。。。
现在直接说怎么解决
初始化的时候带上:skip-grant-tables
mysqld --defaults-file=/path/my.cnf --skip-grant-tables &
然后连接mysql,进入后看下root账号的信息
select * from mysql.user where user='root';
发现麻蛋这个字段password_expired的是是Y,改成N就可以了
update mysql.user set password_expired='N'where user='root';
到此问题就解决了
麻蛋,这个问题困惑了好久,折腾了几个晚上,我同一台机子,其他两个实例就没这问题,真是诡异
阅读全文
0 0
- mysql5.7初始化后连接mysql的时候报:Your password has expired.
- mysql your password has expired
- mysql your password has expired
- mysql错误:your password has expired..
- Your password has expired的解决办法
- mysql错误之------- mysql your password has expired
- MYSQL ERROR 1862 (HY000): Your password has expired.
- MySQL错误号码1862:your password has expired
- MYSQL ERROR 1862 (HY000): Your password has expired.
- MySQL错误号码1862:your password has expired
- MySQL错误号码1862:your password has expired
- MYSQL ERROR 1862 (HY000): Your password has expired.
- MySQL错误号码1862:your password has expired
- MYSQL ERROR 1862 (HY000): Your password has expired.
- mysql密码过期的修改方法(your password has expired)
- MySQL5.7出现Your password has expired. To log in you must change it using a client that supports expir
- MySQL5.7出现Your password has expired. To log in you must change it using a client that supports expir
- mysql5.7密码过期ERROR 1862 (HY000): Your password has expired. To log in you must chang
- Java笔记9
- 几种常见排序算法
- Unity3D数学之路——Vector3类(一)
- BZOJ1614 [Usaco2007 Jan]Telephone Lines架设电话线 二分/魔性剪枝/最小边长连通
- Unity3D ScrollView跳转功能
- mysql5.7初始化后连接mysql的时候报:Your password has expired.
- pat乙级真题 1068. 万绿丛中一点红(20)
- [Vue]不能使用索引直接修改数组,但可以使用索引更新对象数组内的属性
- [JS] 改自网络:单行任意数量条公告循环滚动代码
- 复习系列--javascript数组的常用方法总结
- Hibernate入门(四)之持久化对象的三种状态
- Slim中的集合类Collection
- 使用原生js读取树形结构对象构筑多级结构菜单
- hibernate详细脑图