MySQL Time Zone Modification
To modify your MySQL server's time zone from UTC to GMT 1, follow these steps:
Database Access via PHPMyAdmin
SET GLOBAL time_zone = '+01:00'; SET time_zone = '+01:00';
Using Named Time Zones
For time zones that observe daylight saving time, use named time zones like this:
SET GLOBAL time_zone = 'Europe/London';
Addressing "Unknown or Incorrect Time Zone" Error
If you encounter the error "Unknown or incorrect time zone" for Linux systems, follow these steps:
mysql_tzinfo_to_sql /usr/share/zoneinfo/|mysql -u root mysql -p
SET GLOBAL time_zone = timezone;
The above is the detailed content of How to Change MySQL Server Time Zone from UTC to GMT 1 (or other Time Zones)?. For more information, please follow other related articles on the PHP Chinese website!