Windows MySQL View log log to synchronize log and system time

1. To view log log, modify the configuration file My.ini and modify it under [mysqld]:

2. After the modification, restart the MySQL service to take effect;

3. The Error_log,slow_log log timestamp defaults to UTC after the default installation, resulting in inconsistent with the system time and 8 hours from Beijing time

Because Log_timestamps is a global parameter, the set global parameter is directly after login and will be invalidated after reboot.

It is therefore necessary to add a log_timestamps configuration in the MySQL configuration file [mysqld]:

Log_timestamps=system

Windows MySQL View log log to synchronize log and system time