# mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
mysql> set global time_zone='Europe/Istanbul';
Query OK, 0 rows affected (0.00 sec)
mysql> set global log_timestamps="system";
Query OK, 0 rows affected (0.00 sec)
veya
mysqld.cnf de
mysqld
default-time-zone = "Turkey"
veya
default-time-zone = "Europe/Istanbul"
log_timestamps="system"
mysql> SELECT @@global.time_zone;
+--------------------+
| @@global.time_zone |
+--------------------+
| Turkey |
+--------------------+
1 row in set (0.00 sec)
mysql> select now(); system date;
+---------------------+
| now() |
+---------------------+
| 2022-03-31 19:46:26 |
+---------------------+
1 row in set (0.00 sec)
Thu Mar 31 19:46:26 +03 2022
mysql>
[root@adminlinux ~]# head /var/log/mysqld.log
2022-03-25T11:17:24.066701Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-18) starting as process 21860
2022-03-25T11:17:24.088451Z 0 [Warning] [MY-010075] [Server] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 254bf671-ac2d-11ec-b68d-525400cdac00.
2022-03-25T11:17:24.096120Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2022-03-25T11:17:24.096185Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-03-25T11:17:24.115078Z 1 [ERROR] [MY-012224] [InnoDB] Tablespace flags are invalid in datafile: ./ibdata1, Space ID:0, Flags: 21. Please refer to
[root@adminlinux ~]# tail /var/log/mysqld.log
Version: '5.7.36-39-57-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Percona XtraDB Cluster (GPL), Release rel39, Revision 5197785, WSREP version 31.55, wsrep_31.55
2022-03-31T19:52:53.459363+03:00 2 [Note] WSREP: Initialized wsrep sidno 2
2022-03-31T19:52:53.459389+03:00 2 [Note] WSREP: Auto Increment Offset/Increment re-align with cluster membership change (Offset: 1 -> 1) (Increment: 1 -> 1)
2022-03-31T19:52:53.459428+03:00 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-03-31T19:52:53.459454+03:00 2 [Note] WSREP: Assign initial position for certification: 17, protocol version: 4
2022-03-31T19:52:53.459477+03:00 0 [Note] WSREP: Service thread queue flushed.
2022-03-31T19:52:53.459506+03:00 2 [Note] WSREP: GCache history reset: 6b23794e-b10f-11ec-9e36-fb8d241d3e07:0 -> 6b23794e-b10f-11ec-9e36-fb8d241d3e07:17
2022-03-31T19:52:53.464572+03:00 2 [Note] WSREP: Synchronized with group, ready for connections
2022-03-31T19:52:53.464595+03:00 2 [Note] WSREP: Setting wsrep_ready to true
2022-03-31T19:52:53.464600+03:00 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
[root@adminlinux ~]#
