使用Druid创建MySQL链接时在DruidAbstractDataSource.createPhysicalConnection产生SQLException异常

 一、使用Druid创建数据库链接时报错

2023-02-15 15:53:49.353 [planflight] [Druid-ConnectionPool-Create-1819862363] ERROR [DruidDataSource.java:2471] - create connection sqlException, url: jdbc:Mysql:127.0.0.1:3306/test?characterEncoding=utf8&useSSL=false&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true, errorCode 0, state nulljava.sql.SQLException: connect error, url jdbc:mysql:127.0.0.1:3306/test?characterEncoding=utf8&useSSL=false&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true, driverClass com.mysql.cj.jdbc.Driver   at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1627)   at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2468)

二、造成本次异常原因 

根本原因为jdbc-url错误，标准格式为

jdbc:mysql://[host][:port]/[database]

例如本例应修改为

jdbc:mysql://127.0.0.1:3306/test?characterEncoding=utf8&useSSL=false&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true

注意斜线等内容

来源地址：https://blog.csdn.net/qq_23915881/article/details/129046029