MySQL 8.0出现安装错误总结

1、MySQLNonTransientConnectionException: Could not create connection to database server.

因为mysql8和之前的版本的driver不同了：

driver: com.mysql.cj.jdbc.Driver

2、WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

mysql在ssl连接时出了问题：

1.在数据库连接的url中添加useSSL=false;

jdbc:mysql://localhost:3306/test?useSSL=false
如果在双引号里面，url后面又有其他参数，可以使用“&”代替“&”，例如：

"jdbc:mysql://localhost:3306/sql_test?useUnicode=true&characterEncoding=UTF-8&useSSL=false"

 

3、Authentication plugin 'caching_sha2_password' cannot be loaded

因为MySQL8.0改变了身份验证方式,之前版本是mysql_native_password，现在改成了caching_sha2_password。

解决办法：

修改验证方式：

ALTER USER root@localhost IDENTIFIED WITH mysql_native_password BY ‘你的密码’;

因为本机将localhost改成%，所以我需要执行

ALTER USER root@%IDENTIFIED WITH mysql_native_password BY ‘123456’;

 

 

 

参考文章：

https://blog.youkuaiyun.com/qq_15003505/article/details/80463174

http://blog.youkuaiyun.com/u010429286 https://blog.youkuaiyun.com/u010429286/article/details/77750177

https://blog.youkuaiyun.com/zixiao217/article/details/80156362