JDBC連線MySQL8.0.13的記錄

pangsir8983發表於2019-01-19
JDBCMySql
  • 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的配置檔案中直接使用&字元會出錯，需用&來代替

相關文章