• IDEA Manually connect to mysql: Server returns invalid timezone. Go to ‘Advanced’ TAB and set ‘serverTimezone’ property manually.
  • Time zone error, MySQL default time zone is UTC, 8 hours later than Beijing time.

  • Solution: Set serverTimezone to Hongkong in Advanced

  • Test success