At work I have 2 MySQL servers one for Europe(EU) and one for NorthAmerica(NA), each with it’s own timezone. Now the company wants to migrate both servers on only one in EU.
My problem is that for the databases for the original server from NA i still need to insert/update dates at their timezone. So how can i have different timezones on the same server?
Can i set a timezone for schemes or users?