mysql数据库The server time zone value '�й���׼ʱ��' is unrecogni等报错解决

MySQL连接报错

spring.datasource.url连接信息出问题。

报错信息

{
  "timestamp": "2019-11-12T11:07:30.870+0000",
  "status": 500,
  "error": "Internal Server Error",
  "message": "nested exception is org.apache.ibatis.exceptions.PersistenceException: \r\n### Error querying database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.\r\n### The error may exist in file [E:\\eclipse\\workspace\\cms_jd1911\\target\\classes\\mapper\\UserMapper.xml]\r\n### The error may involve com.briup.dao.UserMapper.selectByExample\r\n### The error occurred while executing a query\r\n### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.",
  "trace": "org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: \r\n### Error querying database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.\r\n### The error may exist in file [E:\\eclipse\\workspace\\cms_jd1911\\target\\classes\\mapper\\UserMapper.xml]\r\n### The error may involve com.briup.dao.UserMapper.selectByExample\r\n### The error occurred while executing a query\r\n### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.\r\n\tat org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)\r\n\tat org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)\r\n\tat com.sun.proxy.$Proxy75.selectList(Unknown Source)\r\n\tat org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:223)\r\n\tat org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)\r\n\tat org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)\r\n\tat org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:93)\r\n\tat com.sun.proxy.$Proxy76.selectByExample(Unknown Source)\r\n\tat com.briup.service.impl.UserImpl.findAll(UserImpl.java:30)\r\n\tat com.briup.web.controller.TestController.findAll(TestController.java:28)\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ