JDBC連線MySQL8.0.13的記錄

• MySQL版本8.0開始jdbc連線資料庫的驅動變更：com.mysql.cj.jdbc.Driver
• 同時密碼儲存方式改變為 caching_sha2_password
• 需要修改MySQL配置檔案中的default_authentication_plugin為mysql_native_password（不使用）
• 修改原有賬戶的加密方式：ALTER USER `root`@`localhost` IDENTIFIED WITH mysql_native_password BY `新密碼`;

如果報錯Unknown system variable `query_cache_size`，則為jdbc版本不一致導致，更換jdbc驅動版本即可

出現警告：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

• 只需要在資料庫url後加上：useSSL=false 該問題我沒有遇到

• 問題：java.sql.SQLException: The server time zone value

  • 時區錯誤，在url後新增：serverTimezone=UTC

mybatis的配置檔案中直接使用&字元會出錯，需用&來代替