I have a host running in a different time-zone from where I am operation and unless I set the website time zone to the hosting time zone I get the following error in CiviCRM:
Timestamps reported by MySQL (eg "2018-03-07 12:20") and PHP (eg "2018-03-07 11:20" ) are mismatched.
I know that my PHP time is correct, but how can I force the MySQL time to be set to my local time.
I've looked through the available answers but most of them advise setting the website timezone to match the host time, which is suboptimal
Is there anything that I can do to still be able to work in my time zone?