ALTER USER 'root'@'localhost' IDENTIFIED BY 'pass' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'%' IDENTIFIED BY 'pass' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'pass';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'pass';
FLUSH PRIVILEGES;
转载于:https://my.oschina.net/u/3350266/blog/3019760