MySQL：Your password has expired. To log in you must change it using a client that supports expired p...

MySQL：V5.6.37

安装后发现没远程权限，为了方便，就直接把hostname@root修改为%@root，密码修改为和localhost@root一样

然后尴尬的事情发生了，本地登陆正常，远程登陆提示密码过期

解决的方式简单粗暴：
mysql:
use mysql;
update user set password_expired='N';
flush privileges;
exit;

然后就搞定！

转载于:https://www.cnblogs.com/music378/p/9179648.html