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?
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