change mysql timezone to UK

Question

I want to change mysql default timezone to UK timezone,

I have no access to mysql config file. Is there any way that I can do this on query level.

So once the query executed then it will save date based on Uk timezone,

Thanks

Answer 1

client can change its own time zone with this statement:

SET time_zone = '+0:00';

Answer 2

In the configuration file you are loading you can set the timezone with the default-time-zone='timezone' directive e.g.

default-time-zone='+00:00'

for UTC. There is more information in the MySQL timezone reference manual

Edit:

To change your timezone on the fly use the SET GLOBAL time_zone = 'timezone' ; command e.g.

mysql -u root -p
your password

mysql> SELECT @@global.time_zone;
+--------------------+
| @@global.time_zone |
+--------------------+
| SYSTEM             |
+--------------------+
1 row in set (0.00 sec)

mysql> SET GLOBAL time_zone = '+00:00';
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT @@global.time_zone;
+--------------------+
| @@global.time_zone |
+--------------------+
| +00:00             |
+--------------------+
1 row in set (0.00 sec)