idea connect to database error Server returns invalid timezone. Need to set ‘serverTimezone’ property
the reason is that the default time zone in MySQL driver is UTC, which is eight hours different from local time (China), so the link cannot be connected.
click on Set time zone
1. Fill in GMT in the box and save! 
2. You can also add:?After the URL. serverTimezone=GMT
PS:
GMT (Greenwich Mean Time) : Greenwich Mean Time
UTC: world Standard Time
CST (China Standard Time) : China Standard Time
GMT + 8 = UTC + 8 = CST
Read More:
- Top35: pychar reports an error when connecting to MySQL server returns invalid timezone. Need to set ‘servertimezone’ property
- Idea: server returns invalid timezone. Need to set ‘servertimezone’ property
- Uncaught typeerror: cannot set property ‘of null error resolution
- Curl returns empty reply from server. Due to the processing of special characters, curl cannot be accessed and the browser can access it.
- About WLW (Windows Live Writer): “unable to connect to your log service: invalid server response” solution
- uncaught typeerror:cannt set property ‘0‘ of undefined
- [Solved] Failed to set attribute: Invalid input data or parameter
- Local can link to the server database, upload jar package to the server will report an error
- Pychar reported an error. Unable to set the python SDK in Python 3.8. This SDK appears to be invalid.
- Bug001: error in gradle configuration environment variable: ERROR:JAVA_ Home is set to an invalid directory!
- CentOS Liunx 7 uses rdesktop to remotely connect to the Alibaba Cloud server and it appears Failed to connect, CredSSP required by server.
- How to Solve mybatis returns null when querying Oracle database with char type field
- The server just without updating PID file and can’t connect to local MySQL server through socket are solved
- RegOpenKeyEx returns error value 5
- torch.cuda.is_ Available() returns false
- Validation error: webpack dev server invalid options
- gateway Internal Server Error 500 Invalid host: lb://xxxxxx
- About MySQL error: subquery returns more than 1 row
- Postman returns to the data window and displays the JSON format by default
- Macfee can not be upgraded, the prompt returns an error