#1312 (ok 4.4) set time_zone for session

[Oleg Kochetilov]

I need to set (or select) time_zone for session of phpMyAdmin. It's useful becasue the system is on a web-hosting and I can not select time_zone for server, but if I could select it on server page of phpMyAdmin along with MySQL connection collation and Language and then setted value were added to all queries as "SET time_zone = '+4:00';" for example. It would be great, because all timestamps will be in the local time.

[PHPcian]

Has anyone worked on this feature request?

[uzb]

+1

This is not only needed for shared hosting, but also on cloud platforms like AWS.

Amazon AWS does not allow us to set the time zone in the mysql configuration. We have updated our applications to execute the above command to have the correct time zone during the sessions.

Unfortunately, there is no such option in PMA. This may lead to incorrect values when using statements like NOW(), which is inconsistent with our applications, and may lead to potential bugs. That's why we really need this.

[uzb]

I created a pull request for this feature:

https://github.com/phpmyadmin/phpmyadmin/pull/1495