|
|
错误: 您的Cacti数据库登录帐户无权访问MySQL TimeZone数据库。 请提供Cacti数据库帐户对 "mysql" 数据库中 "time_zone_name" 表的 "select" 访问权,并在继续之前填充MySQL的TimeZone信息。
* c9 \1 [! \' F' f! I) s, G. S6 k1 u( Q1 w4 b4 B
{3 n. P( z& B; G, ~) D
4 D3 R0 H% z, t- o, s
[root@ceph1 html]# mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql( R7 @' y2 X- d0 k- L( U
Enter password: 4 E$ z' ?$ o0 b# R8 \ s% r0 s3 e
Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.& W, X C/ d- n& M+ Q' f
4 X- x: H% b8 gWarning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.- c+ I- y1 l" a" c9 U8 X2 l
0 |8 r. F* w2 e$ q[root@ceph1 ~]# mysql -u root -p) [/ I- U5 ]1 G
Enter password:
* O: |5 F+ T, n, i L* B, ^Welcome to the MariaDB monitor. Commands end with ; or \g.- z6 G3 e o! E% I) B# x1 W# T
Your MariaDB connection id is 71 H/ W, H. N) h7 l; y' ]
Server version: 5.5.68-MariaDB MariaDB Server- D H+ g; }; l8 g
! |* s1 T) E: y, ?2 _4 u
8 ~ u( C% b4 d/ K
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.+ Q5 t. i9 r5 |/ F" ~
4 l" w, V; ~, j% F) K
8 w: h3 j, l2 f. s4 _$ TType 'help;' or '\h' for help. Type '\c' to clear the current input statement.: t( G+ d& K+ p9 I* x9 Y
- H: |- c/ h3 f& d2 @5 v8 A. V P3 f
' a m3 P) h8 d6 [! s( e2 j: oMariaDB [(none)]> GRANT SELECT ON mysql.time_zone_name TO cactiuser@localhost IDENTIFIED BY 'cactiuser';
$ n+ |5 v7 l, F: l0 QQuery OK, 0 rows affected (0.00 sec)" z8 W' p. F6 w6 M8 X# ~7 T/ J
; \; G: k2 {# s
0 U0 I5 _) U7 e* H$ T% a4 h* l( @
|
|