Software Version
Problem DescriptionWhen java saves the current time to MySQL database, the time in MySQL is incorrect Problem Analysis Reason 1: Java database connection uses the UTC time zone (universal time), that is, serverTimezone=UTC url: jdbc:mysql://localhost:3306/test?serverTimezone=UTC&useUnicode=true&characterEncoding=utf8&useSSL=true Reason 2: The time_zone attribute used by MySQL is +00:00, and Beijing time is 8 hours earlier than UTC time, that is, UTC+08:00 Check MySQL/** * You can view the global time zone settings and session time zone settings * global.time_zone is responsible for the time zone setting when java connects to the database * session.time_zone is responsible for the time zone setting when the Navicat client connects to the database * / mysql> select @@global.time_zone,@@session.time_zone; /** * There is another method * System represents the use of system time zone * CST is a very messy time zone, it includes 4 time zones * / mysql> show variables like '%time_zone%'; // Verify the time zone. This command line can detect whether session.time_zone is configured correctlymysql> select now(); Workaround Step 1: Change the time zone in Java to East 8 // serverTimezone can be set to Beijing time GMT%, Shanghai time Asia/Shanghai or Hongkong time Hongkong url: jdbc:mysql://localhost:3306/test?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8&useSSL=true Step 2: Change the time zone of the MySQL database to East 8 // Method 1: Use command (Advantage: No need to restart MySQL service, Disadvantage: Once MySQL service is restarted, the settings will disappear) mysql> set time_zone = '+8:00'; mysql> set global time_zone = '+8:00'; // Method 2: Modify the my.ini configuration file (Advantage: Permanently save settings, Disadvantage: Need to restart the MySQL service) [mysqld] // Set the default time zone default-time_zone='+8:00' This is the end of this article about the steps to solve the MySQL 8.0 time zone problem. For more relevant MySQL 8.0 time zone content, please search 123WORDPRESS.COM's previous articles or continue to browse the following related articles. I hope everyone will support 123WORDPRESS.COM in the future! You may also be interested in:
|
<<: How to create your own Docker image and upload it to Dockerhub
>>: XHTML language default CSS style
UPD 2020.2.26 Currently Ubuntu 20.04 LTS has not ...
When you send a network request, the following sa...
React Hooks is a new feature introduced in React ...
reason: MySQL 5.7.5 and up implements detection o...
Preface Note: The test database version is MySQL ...
Experimental environment A minimally installed Ce...
Table of contents 1. Main functions 2. Implementa...
This article example shares the specific code of ...
One-click execution To install Python 3.8 in a vi...
This article example shares the specific code of ...
1. In the previous chapter, we learned that we ca...
This article uses an example to describe the solu...
Why do we need virtual dom? Virtual DOM is design...
In the previous article, I introduced the basic k...
Overview For small and medium-sized projects, joi...