设置并查询mysql数据库时区

最新推荐文章于 2025-01-03 10:24:40 发布

做我心上人

最新推荐文章于 2025-01-03 10:24:40 发布

阅读量321

点赞数

分类专栏：信息资源文章标签： mysql

本文链接：https://blog.youkuaiyun.com/zlcx6/article/details/113545702

版权

信息同时被 2 个专栏收录

31 篇文章

订阅专栏

资源

11 篇文章

订阅专栏

mysql> set global time_zone = '+8:00';
1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation
mysql> set time_zone = '+8:00';
Query OK, 0 rows affected

mysql> flush privileges ;
1227 - Access denied; you need (at least one of) the RELOAD privilege(s) for this operation
mysql> flush privileges ;
1227 - Access denied; you need (at least one of) the RELOAD privilege(s) for this operation
mysql> show variables like '%time_zone%';
+------------------+--------+
| Variable_name    | Value  |
+------------------+--------+
| system_time_zone | CST    |
| time_zone        | +08:00 |
+------------------+--------+
2 rows in set