在一台服务器上，当我运行:
mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2009-05-30 16:54:29 |
+---------------------+
1 row in set (0.00 sec)
在另一台服务器上:
mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2009-05-30 20:01:43 |
+---------------------+
1 row in set (0.00 sec)
当前回答
要在MariaDB中设置标准时区，必须转到50-server.cnf文件。
sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf
然后您可以在mysqld部分中输入以下条目。
default-time-zone='+01:00'
例子:
#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see
#
# See the examples of server my.cnf files in /usr/share/mysql/
#
# this is read by the standalone daemon and embedded servers
[server]
# this is only for the mysqld standalone daemon
[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
### Default timezone ###
default-time-zone='+01:00'
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
必须通过配置文件进行更改，否则MariaDB服务器重启后将重置mysql表!
其他回答
这个工作为我在印度的一个位置:
SET GLOBAL time_zone = "Asia/Calcutta";
SET time_zone = "+05:30";
SET @@session.time_zone = "+05:30";
要在MariaDB中设置标准时区，必须转到50-server.cnf文件。
sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf
然后您可以在mysqld部分中输入以下条目。
default-time-zone='+01:00'
例子:
#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see
#
# See the examples of server my.cnf files in /usr/share/mysql/
#
# this is read by the standalone daemon and embedded servers
[server]
# this is only for the mysqld standalone daemon
[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
### Default timezone ###
default-time-zone='+01:00'
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
必须通过配置文件进行更改，否则MariaDB服务器重启后将重置mysql表!
如果您正在使用MySql Workbench，您可以通过打开管理员视图并选择Advanced选项卡来设置这一点。顶部部分是“Localization”，第一个复选框应该是“default-time-zone”。选中复选框，然后输入您想要的时区，重新启动服务器，您应该可以开始了。
MySQL和PHP的时区设置:
记住:
更改时区系统。Ubuntu的例子: $ sudo dpkg-reconfigure tzdata 重启服务器或者重启Apache 2和MySQL: /etc/init.d / mysql重启
对于仍然有这个问题的人:
value="jdbc:mysql://localhost:3306/dbname?serverTimezone=UTC"
为我工作。只需在末尾附加?serverTimezone=UTC。
