mysql5.7修改密码提示ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
开始我以为是语句错误,后面再三确认以后,发现不是,于是就去查找解决方法
如下:
1.初始密码登录数据库:mysql -u root -p
2.set password = password(‘新密码’);
3.alter user ‘root’@‘localhost’ password expire never;
4.flush privileges;
5.退出用新密码登录
欢迎有兴趣的朋友加入运维群交流学习!!!
微信:zdqqbb