针对其他用户能够连接服务器mysql,但是本地连接报错 'Your password has expired. To log in you must change it using a client that supports expired passwords.';解决方案如下:
进入mysql所在目录用CMD运行
Mysql>mysql -u root -p 回车后输入密码
Mysql>use mysql;
Mysql>update user set password=PASSWORD(‘root’) where user=’root’;
Mysql>flush privileges;
Mysql>quit;
解决后发现本机现能用127.0.0.1与localhost能够连接,却不能用自己的