Python linked database reports an error: server returns invalid timezone Go to ‘Advanced‘ tab and set ‘serverTimezone‘ proper
編輯:Python
Reference resources :IDEA Connect mysql An error again :https://blog.csdn.net/liuqiker/article/details/102455077
Set up MySQL The time zone
Operation steps
(1) Enter the command window (Win+r, Input cmd)(2) Input :mysql -hlocalhost -uroot -p( Linked database )(3) Input :show variables like’%time_zone’; ( View the database time zone )(4) Input :set global time_zone = ‘+8:00’;( Set time zone )