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

admin

错误： 您的Cacti数据库登录帐户无权访问MySQL TimeZone数据库。 请提供Cacti数据库帐户对 "mysql" 数据库中 "time_zone_name" 表的 "select" 访问权，并在继续之前填充MySQL的TimeZone信息。
: u! Q+ X0 x2 {


; l* ]  I# ~  G. q8 {  y7 C- y9 i[root@ceph1 html]# mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql
Enter password:
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.
) B' u  q3 o1 G" k% H7 \
[root@ceph1 ~]# mysql -u root -p
2 y" G- |! @4 ~# V, r( QEnter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 7
8 c  P- X/ R5 [6 GServer version: 5.5.68-MariaDB MariaDB Server


2 o, P3 \$ Q1 W  ^: d3 DCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
$ U) j. D" c+ _

- \+ {8 I* G; n6 K6 S& GType 'help;' or '\h' for help. Type '\c' to clear the current input statement.


9 N. |' T; G9 d  m* }MariaDB [(none)]>  GRANT SELECT ON mysql.time_zone_name TO cactiuser@localhost IDENTIFIED BY 'cactiuser';
Query OK, 0 rows affected (0.00 sec)

5 I) m) k+ n# w9 R' L* ]
3 V& \2 Y* u1 T$ L9 I- c

admin

mysql> GRANT SELECT ON mysql.time_zone_name TO cactiuser@'localhost' IDENTIFIED BY 'cactiuser';
* `4 g# A+ x5 J' d, b' l" }; `6 \5 `) XQuery 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
Enter password:
3 J& w& s9 Q- ^8 a' `# Q% NWarning: 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.
Warning: 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