使用MySQL时出现The server time zone value '�й���׼ʱ��' is unrecogni的解决方法

原文链接： https://blog.csdn.net/jisuanjiguoba/article/details/100014214

使用MySQL时出现The server time zone value '�й���׼ʱ��' is unrecogni的解决方法

                </div>
                                                
                                    
            <div class="htmledit_views" id="content_views">
                                        <p>开发数据库相关的项目时，出现如下的异常：org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: <span>The server time zone value '�й���׼ʱ��' is unrecognized or represents more than one time zone. </span>You must configure either the server or JDBC driver (<span>via the serverTimezone configuration property) to use a more specifc time zone value</span> if you want to utilize time zone support.</p>

解决办法：

根据提示需要在配置数据库的连接信息中，在MySQL的URL后面加上“?serverTimezone=UTC” ，如下所示：

spring.datasource.url=jdbc:mysql://127.0.0.1:3306/test?serverTimezone=UTC
 
 

 
 
1

 

<div class="postTime">
            <div class="article-bar-bottom">
        <div class="reward-user-box">

                                </div>
            <link href="https://csdnimg.cn/release/phoenix/mdeditor/markdown_views-095d4a0b23.css" rel="stylesheet">
                </div>