Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

 

MySQL8.0连接报错

...


便捷解决方案:

 

Warning
mysql 8.0 修改了加密的插件方式,导致很多旧版本的navicat无法正常访问,例如:
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'MyNewPass4!';

...


其它解决方案:


一、新增连接mysql8.0的驱动

       下载驱动 :mysql-connector-java-8.0.17.jar

...