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

admin

错误： 您的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

[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.

4 \4 p; i( x  ]) Z' N! L$ m% v8 ?Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.

[root@ceph1 ~]# mysql -u root -p
Enter password:
# s; J4 o( F! p' `, S% [Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 7
Server version: 5.5.68-MariaDB MariaDB Server
* A/ P; \9 Q8 C5 p4 f$ |2 j

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

2 f+ k7 O# y* V- f/ H
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

- h+ C8 ?" _) c0 I+ J4 q
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)

  L2 v9 L! |) _
" J9 o3 J% J# g; B% J

admin

mysql> GRANT SELECT ON mysql.time_zone_name TO cactiuser@'localhost' IDENTIFIED BY 'cactiuser';
Query OK, 0 rows affected (0.00 sec)

mysql>

admin

[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:
Warning: Unable to load '/usr/share/zoneinfo//iso3166.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo//leapseconds' as time zone. Skipping it.
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.
Warning: Unable to load '/usr/share/zoneinfo//zone1970.tab' as time zone. Skipping it.

admin

[root@ceph1 ~]# vim /etc/php.ini
date.timezone = Asia/Shanghai