首先输入:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
接下来设置密码:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'new password';
最后刷新:
FLUSH PRIVILEGES;
记得编码格式:
?useUnicode=true&characterEncoding=utf8