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

admin

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



+ e8 S/ \3 T$ i! W& n[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.

. r9 ?( U- L' h$ D: e8 M/ H& i" TWarning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.

[root@ceph1 ~]# mysql -u root -p
Enter password:
  ]/ K. C. n% I/ g: f7 mWelcome to the MariaDB monitor.  Commands end with ; or \g.
- }' b" {+ D6 ^( ?  zYour MariaDB connection id is 7
Server version: 5.5.68-MariaDB MariaDB Server

3 R3 D) P- t5 |3 f
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

6 q  t: U; E* D
# J4 n: i+ E; M2 @* g. C6 S; \3 o, hType 'help;' or '\h' for help. Type '\c' to clear the current input statement.
. {8 ^7 o  J$ K3 [/ O- @6 l& J
/ d3 {9 r6 S7 Y2 Q* |* h  t
/ T1 k6 g9 z/ P# T- \4 k% wMariaDB [(none)]>  GRANT SELECT ON mysql.time_zone_name TO cactiuser@localhost IDENTIFIED BY 'cactiuser';
Query OK, 0 rows affected (0.00 sec)

admin

mysql> GRANT SELECT ON mysql.time_zone_name TO cactiuser@'localhost' IDENTIFIED BY 'cactiuser';
" b; @- ~. Y  _+ `6 N/ GQuery OK, 0 rows affected (0.00 sec)
# A& n3 d$ B7 ?5 v
mysql>

admin

[root@ceph1 ~]# /var/lib/mysql/bin/mysql_tzinfo_to_sql /usr/share/zoneinfo/ | mysql -u root -p mysql
5 L% V# r* l# Q' n( n/ vEnter 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.
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