Geek Answers Handbook

Mysql timezone change from phpMyAdmin

I am trying to change the time zone of my database. I am on a shared server and the database support guys cannot change it just for me. The time zone at the moment. +1:00I want it to be +05:30. I searched and tried to follow, but nothing worked.

date_default_timezone_set('timezone_name');

Added to my file index.php.

mysql> SET GLOBAL time_zone = 'timezone_name';

It states that access is restricted.

SET time_zone = timezone_name

Error executing query string.

My site is hosted on a server with a site server.

+4
source share
3 answers

, . , , datetime sql , madipradhana , php.ini .htaccess.

+3

, .htacess, PHP- MySQL. .htaccess, , .

SetEnv TZ your_timezone

, ,

SetEnv ID Asia/Jakarta

:

http://php.net/manual/en/timezones.php

+2

, date() php date_default_timezone_set('timezone_name'); index.php

+2

More articles:


All Articles