解决方案1:
通过修改mysql的配置文件,强制mysql权限用户为mysql_native_password 模式
https://www.cnblogs.com/wangziyue/p/10642809.html
解决方案2:
新建一个mysql_native_password 用户:
CREATE USER 'zxl'@'127.0.0.1' IDENTIFIED WITH mysql_native_password BY 'root';
GRANT ALL PRIVILEGES ON *.* TO 'zxl'@'127.0.0.1' WITH GRANT OPTION;
修改一个mysql_native_password 用户:
alter user 'zxl'@'127.0.0.1' identified with mysql_native_password by "root";
GRANT ALL PRIVILEGES ON *.* TO 'zxl'@'127.0.0.1' WITH GRANT OPTION;