search

ErSKS / KhCE

Khwopa College of Engineering
5 stars 0 forks source link

Set MySQL Time Zone #61

Closed ErSKS closed 7 years ago

ErSKS commented 7 years ago

Local Time Zone is "Asia/Kathmandu";

ErSKS commented 7 years ago

SET @@session.time_zone='+05:45'; SELECT * FROM my_table

ErSKS commented 7 years ago

Error SQL query:

SET GLOBAL time_zone = 'Asia/Kathmandu' MySQL said: Documentation

1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation