Changing Local Time Zone for MySQL 

thank you. friend

SQL query: SET GLOBAL time_zone = '+5:30' MySQL said: Documentation #1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation

will it change existing rows time also ?

thank you so much

Bhai aap konsi hosting use krte ho, me bluehost use krta hu usme timezome change nhi ho rha h, UTC bhi nhi h, MDT likha aata h , india ke time se 30 minute aage h , please help, kese change kru

In on Mac it did not work. It only worked temporally. When I restart xampp the phpMyAdmin the timezone was reset.

OMG, thank you so much TSL! *subscribed*.

WHEN I try this it shows : "#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation" plz resolove it

it worked but when i reset my microcontroller where i made my database it goes back to the same problem

thank you sir. ever grateful for this

I get this error does anyone know how to fix it? # 1067 invalid default value for ' time '

Thanks! It helped me a lot!!!

Thanks!! Very useful for me :)

Thank you for your tutorial

Thanks

how to reverse this to default ?

for india what will be the value