今天打开SQLyog提示密码过期：Your password has expired
解决方法：
1. 启动MySQL服务
2. 启动MySQL后台
3. 执行以下命令
- step 1: SET PASSWORD = PASSWORD('your new password');
- step 2: ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
- step 3: flush privileges;
4. 重启MySQL服务
相关文章
- windows下忘记mysql超级管理员root密码的解决办法(也适用于wamp） 如果报错 You must reset your password using ALTER USER statement before executing this statement.解决Your password has expired. To log in you must change it using a client that supports expired passwo
- mysql5.7密码过期ERROR 1862 (HY000): Your password has expired. To log in you must change
- Linux 密码过期（WARNING:Your password has expired ）
- WARNING:Your password has expired --linux 用户密码过期
- MySQL错误代码1862 your password has expired的解决方法