lalifeier的博客

MySQL8.0新的密码认证方式The caching_sha2_password and sha256_password authentication plugins provide more secure password encryption than the mysql_native_password plugin, and caching_sha2_password provide...

环境：JDK9、MYSQL8、idea报错信息如下Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'.根据上面提示修改jdbc.properties配置 中com.mysql.jdbc.Driver 改为com...

在连接数据库的url中，加上allowPublicKeyRetrieval=true

修改my.ini，重启Mysql服务# SQL模式sql-mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"