更改phpmyadmin的默认TimeZone

Question

I created a QueryLog table and had a column of date-time. I set the default value to that as timestamp, but the timestamp is 2 hours earlier. How can I set the default timestamp to my time?

Answer 1

In your file php.ini

[Date]<br />
; Defines the default timezone used by the date functions<br />
; http://php.net/date.timezone<br />
date.timezone ="Africa/Kigali"<br />

For More detail time-zone-support

Please Refer this SO Question: setting-timezone-for-mysql-using-phpmyadmin