MySQL5.7 modify root After account password , Use SqlYog When logging in, the password has expired ：
You need to set it so that the password will never expire ：
- Log in mysql
mysql -uroot -p
Enter password: *******
- Change Password （ This must be carried out , Otherwise, there’s something wrong with the third tip ）
set password= password(‘root’);
- Settings never expire
alter user ‘root’@‘localhost’ password expire never;