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

admin

错误： 您的Cacti数据库登录帐户无权访问MySQL TimeZone数据库。 请提供Cacti数据库帐户对 "mysql" 数据库中 "time_zone_name" 表的 "select" 访问权，并在继续之前填充MySQL的TimeZone信息。
$ t; U/ x; }: b0 }- K( F% e% Y

8 M+ N1 v, ^1 Y% u$ g9 ]
2 E! Y  [. e( Q  q[root@ceph1 html]# mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql
3 W" ]( c' ^8 q5 H. K. V$ WEnter password:
Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.

# |' V- Y( Q3 E* r( t2 m1 y3 a0 aWarning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.

" q9 }! D2 H3 G# A  O3 |  n- Q[root@ceph1 ~]# mysql -u root -p
6 Y* j# j5 O+ O/ C2 n5 uEnter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
* n7 b4 e$ R" q0 b8 eYour MariaDB connection id is 7
2 w% a4 w. n( lServer version: 5.5.68-MariaDB MariaDB Server


5 ~7 K& t, {. m( s$ Z2 T" ^5 q, l: bCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

+ J- {8 V8 L% O. l6 h3 V! U
- y6 D6 B& \( Y8 IType 'help;' or '\h' for help. Type '\c' to clear the current input statement.

: J/ v) Z  s+ C: v. a
MariaDB [(none)]>  GRANT SELECT ON mysql.time_zone_name TO cactiuser@localhost IDENTIFIED BY 'cactiuser';
5 V+ F( |5 [! N7 U0 BQuery OK, 0 rows affected (0.00 sec)
7 I3 Z1 u/ W) J3 f" r
# D7 G+ G# W7 v# V* N( t: m

admin

mysql> GRANT SELECT ON mysql.time_zone_name TO cactiuser@'localhost' IDENTIFIED BY 'cactiuser';
Query OK, 0 rows affected (0.00 sec)
: ?$ H% e* `! e
/ ~1 X  w, E' m5 i, a' M7 D- rmysql>

admin

[root@ceph1 ~]# /var/lib/mysql/bin/mysql_tzinfo_to_sql /usr/share/zoneinfo/ | mysql -u root -p mysql
Enter 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.
( `+ o: }- _5 N  D/ g! E3 gWarning: 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