|
|
错误： 您的Cacti数据库登录帐户无权访问MySQL TimeZone数据库。 请提供Cacti数据库帐户对 "mysql" 数据库中 "time_zone_name" 表的 "select" 访问权，并在继续之前填充MySQL的TimeZone信息。
+ G. {# ]. R& W" M' C# \: H: B/ |8 K2 V. B5 E7 {0 r9 @; h
7 O/ Z" V1 b, c7 f6 n s
+ L L/ e/ A k: ~. m: \- T[root@ceph1 html]# mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql" x, ~, B; ` k; T# \# F0 w
Enter password: 9 c+ C$ H0 u% y, I9 ]! D0 B. X
Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.( b B$ O5 Y, L f3 u: k$ m1 f
) ], S8 y9 o# P1 j3 Q1 l; O) k$ ?% O
Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
! k# p6 S8 N+ h4 m! c1 n+ A1 ^% K1 r1 f! L, w! k0 t2 q e% d' M
[root@ceph1 ~]# mysql -u root -p
$ ^3 v t4 V* i7 f/ @$ `Enter password:
6 n# P" u/ T4 wWelcome to the MariaDB monitor. Commands end with ; or \g.
* ]4 u" s8 I+ p; TYour MariaDB connection id is 7
5 S# J- S, k4 _+ i# K+ t& e/ l# yServer version: 5.5.68-MariaDB MariaDB Server0 O* J, i2 | ]8 T8 q ^
5 V5 |1 K' p d; d, f' q( h- u
" E6 A# ~! W8 J& L
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.& r4 G! [2 k, j- r% O' f
) g/ s M6 } z- V+ d& N! M1 t
; t2 p5 }! L4 p9 G/ k- J7 ~Type 'help;' or '\h' for help. Type '\c' to clear the current input statement./ n G- b% y' R' G& A. z; G/ m- F
; y' p; o# M$ Z
' G5 T1 Y: w D7 a# WMariaDB [(none)]> GRANT SELECT ON mysql.time_zone_name TO cactiuser@localhost IDENTIFIED BY 'cactiuser';
. K0 F; v; w( F6 B" m3 DQuery OK, 0 rows affected (0.00 sec)
4 u$ a! |, R( q3 q1 V
% F* q4 Q0 {. {1 c# C. a4 U, b0 k. R! u. ]( s7 p1 {
|
|
发表于 2022-9-21 17:00:00