易陆发现互联网技术论坛

 找回密码
 开始注册
查看: 934|回复: 3
收起左侧

错误: 您的Cacti数据库登录帐户无权访问MySQL TimeZone数据库。 请提供Cacti数据库帐户对 "mysql" 数据库中 &

[复制链接]
发表于 2022-9-21 17:00:00 | 显示全部楼层 |阅读模式

马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。

您需要 登录 才可以下载或查看,没有账号?开始注册

x
错误: 您的Cacti数据库登录帐户无权访问MySQL TimeZone数据库。 请提供Cacti数据库帐户对 "mysql" 数据库中 "time_zone_name" 表的 "select" 访问权,并在继续之前填充MySQL的TimeZone信息。
" o4 x% w4 U2 Z# r) N/ S. }1 S
+ n  X* r4 n3 Q# Y0 g/ S  a& c4 x1 I% a9 T7 d5 i8 T
4 t5 Z) q* Q* i; \. }
[root@ceph1 html]# mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql
3 z3 b/ }' @/ |$ SEnter password:
/ h: V8 z6 s. x4 W' v4 Y5 qWarning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.+ m7 J( T$ d. {4 I% a

4 \4 p; i( x  ]) Z' N! L$ m% v8 ?Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.8 Q+ z* i, e0 z- b5 d9 z8 w+ u4 O
7 w3 k  o) D2 V0 P' e  X
[root@ceph1 ~]# mysql -u root -p9 `; s6 E+ l  B
Enter password:
# s; J4 o( F! p' `, S% [Welcome to the MariaDB monitor.  Commands end with ; or \g.+ h3 x7 O3 l  K, Q$ N- Q' Q
Your MariaDB connection id is 7, r* H7 K* S& ^6 Q& @
Server version: 5.5.68-MariaDB MariaDB Server
* A/ P; \9 Q8 C5 p4 f$ |2 j, |# G9 t: f7 N  K* I
0 i; Z+ R/ W% L6 Q: n7 B9 C
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.! s7 O$ N4 i6 `, i

2 f+ k7 O# y* V- f/ H& M6 D3 w, V& p- c9 a9 ?1 R3 D- d
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.# X; [+ F1 D5 Y4 m

- h+ C8 ?" _) c0 I+ J4 q& b4 N4 I4 }+ m* ?1 \
MariaDB [(none)]>  GRANT SELECT ON mysql.time_zone_name TO cactiuser@localhost IDENTIFIED BY 'cactiuser';
* V; a1 b8 T7 C! S$ XQuery OK, 0 rows affected (0.00 sec)! C0 Z0 `- M. `2 l6 ^( y9 N

  L2 v9 L! |) _

" J9 o3 J% J# g; B% J
 楼主| 发表于 2022-9-22 14:18:14 | 显示全部楼层
mysql> GRANT SELECT ON mysql.time_zone_name TO cactiuser@'localhost' IDENTIFIED BY 'cactiuser';2 @+ R, a( g, I3 q3 j
Query OK, 0 rows affected (0.00 sec)2 b5 B+ J( g" S# p4 S. t
1 c3 A$ H1 \5 [, [
mysql>
 楼主| 发表于 2022-9-22 17:51:37 | 显示全部楼层
[root@ceph1 ~]# /var/lib/mysql/bin/mysql_tzinfo_to_sql /usr/share/zoneinfo/ | mysql -u root -p mysql
7 G& ^5 Y0 x. zEnter password: 3 c& K5 t; H4 D) a3 E# V
Warning: Unable to load '/usr/share/zoneinfo//iso3166.tab' as time zone. Skipping it.) t- L2 ?. A/ B# M8 _) p2 o
Warning: Unable to load '/usr/share/zoneinfo//leapseconds' as time zone. Skipping it.2 _6 A; W" h0 n! y
Warning: Unable to load '/usr/share/zoneinfo//tzdata.zi' as time zone. Skipping it.
5 Z* L1 T! M1 }4 c2 @6 g& F) EWarning: Unable to load '/usr/share/zoneinfo//zone.tab' as time zone. Skipping it.' B% s9 Q' G1 f5 k3 m- ]9 |9 F3 O
Warning: Unable to load '/usr/share/zoneinfo//zone1970.tab' as time zone. Skipping it.
 楼主| 发表于 2022-9-22 18:00:47 | 显示全部楼层
[root@ceph1 ~]# vim /etc/php.ini # I1 A+ a8 a# r
date.timezone = Asia/Shanghai
您需要登录后才可以回帖 登录 | 开始注册

本版积分规则

关闭

站长推荐上一条 /4 下一条

北京云银创陇科技有限公司以云计算运维,代码开发

QQ|返回首页|Archiver|小黑屋|易陆发现技术论坛 ( 蜀ICP备2026014127号-1 )点击这里给我发消息

GMT+8, 2026-4-8 20:53 , Processed in 0.047948 second(s), 21 queries .

Powered by Discuz! X3.4 Licensed

© 2012-2025 Discuz! Team.

快速回复 返回顶部 返回列表