Could not create connection to database server

在做springMVC+Mybatis项目时,出现了Could not create connection to database server的错误,现已解决,提供思路如下:

  • 检查MySQL版本和JDBC(mysql-connector-java-…)是否一致。打开MySQL Command Line Client 输入SELECT version() FROM dual看MySQL的版本号,若不一致去下载该版本号的JDBC(示例图如????)Could not create connection to database server

若仍提示该错误,则看第二步????

  • 在配置文件mybatis-config.xml找到你连接数据库的url的value,然后在mybatis后加?serverTimezone=UTC(如图????)Could not create connection to database server

另外解决:Loading class com.mysql.jdbc.Driver'. This is deprecated. The new driver class iscom.mysql.cj.jdbc.Driver’. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. 的办法–同样在mybatis-config.xml中,改为如????(加入’cj’)

Could not create connection to database server