设置密码永不过期:
alter user 'root'@'localhost' identified by 'root' password expire never;
链接navicate 2059报错
mysql8 之前加密规则 mysql_native_password 之后是caching_sha2_password
所以处理方案就是更改加密规则 这里改为之前的加密规则:
alter user 'root'@'localhost' identified width mysql_native_password by 'root';