mysql 修改密码后，切记要FLUSH PRIVILEGES

mysql 修改密码后，注意

FLUSH PRIVILEGES 

解决Your password has expired. To log in you must change it using a client that supports expired passwords办法

打开 命令行

1. /usr/local/mysql/bin/mysqladmin -u root -p password  

提示输入按照后的那个密码

输入完成后 提示输入新的密码

1. Enter password:   
2. New password:   

Confirm new password: 

完成

mysql> grant all privileges on *.* to 'root'@'your-host-ip' identified by 'your-mysql-password' with grant option;
mysql> flush privileges;
mysql> exit