SSM框架中报错:
严重: create connection SQLException, url: jdbc:mysql://localhost:3306/test, errorCode 0, state 01S00
java.sql.SQLException: The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
翻译:
严重: 创建连接SQLException,url:jdbc:mysql://localhost:3306/test,错误代码0,状态01S00
java.sql.SQLException:无法识别服务器时区值“?í?ú±ê×?未指定±??”或表示多个时区。如果要使用时区支持,则必须配置服务器或JDBC驱动程序(通过serverTimezone配置属性)以使用更具体的时区值。
解决:在jdbc.properties中url后添加:?useSSL=false&useServerPrepStmts=true&serverTimezone=UTC
jdbc.driver=com.mysql.jdbc.Driver jdbc.url=jdbc:mysql:///test?useSSL=false&useServerPrepStmts=true&serverTimezone=UTC jdbc.username=root jdbc.password=root
- quot SQLException connection errorCode localhostquot sqlexception connection errorcode jdbctemplate sqlexception connection errorcode sqlexception connection localhost错误 sqlexception errorcode access denied 39 sqlexception localhost password quot errorcode 00012005 httpcode hikaridatasource sqlexception connection hikaripool sqlexception connection exception interrupt mysql localhost 39 connect connection the localhost actions