connection to database 'zabbix' failed: [2059] Authentication plugin 'caching_sh

admin

2009:20241023:074318.691 [Z3001] connection to database 'zabbix' failed: [2059] Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory
  2009:20241023:074318.691 Cannot connect to the database. Exiting...
$ Q% m- r4 u/ `
. l( ~  y7 f6 a1 Y1 O. _0 Y* {
2 {5 u- {% a1 l" S) J8 l* ?$ n2 x应该是在配置的时候没有执行数据库zabbix用户的配置：
mysql> alter user 'zabbix'@'localhost' identified with mysql_native_password BY 'Zabbix23@';
  q) Q: S  n- y% qQuery OK, 0 rows affected (0.01 sec)

mysql> flush privilges;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'privilges' at line 1
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

+ |( N4 w# J1 e$ [( e1 D+ Gmysql>

5 `% J. X  k: P; J7 J  2009:20241023:074318.691 [Z3001] connection to database 'zabbix' failed: [2059] Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory
; s: z4 i% e* b( f0 H. F$ x  2009:20241023:074318.691 Cannot connect to the database. Exiting...

; C# o# }# Z# ~7 F+ g+ z
* N6 N0 P& e( Z* O# D/ P; K% ]
% A) N. r, c, X
$ Y0 a, m0 i9 L& H# v& N7 j  2063:20241023:074952.930 Starting Zabbix Server. Zabbix 6.4.20 (revision 114e4f42c15).
9 X9 J- V$ X1 m# U- T  2063:20241023:074952.931 ****** Enabled features ******
  2063:20241023:074952.931 SNMP monitoring:           YES
2 q  Z; i5 G, j0 v( O/ v  2063:20241023:074952.931 IPMI monitoring:            NO
  2063:20241023:074952.931 Web monitoring:             NO
3 ]8 O5 I/ v8 p7 @  X$ ?( R8 I  2063:20241023:074952.932 VMware monitoring:          NO
6 A( Y; \' w% @8 z/ I/ E2 I$ W  2063:20241023:074952.932 SMTP authentication:        NO
! Y* d, c4 q0 d- y" _. m2 t; D' L+ E  2063:20241023:074952.932 ODBC:                       NO
+ d# l# p  x1 e+ t% y: R) l) P  2063:20241023:074952.932 SSH support:                NO
  2063:20241023:074952.932 IPv6 support:               NO
  2063:20241023:074952.932 TLS support:                NO
9 l" d/ `3 X/ f% X) p0 `. H  2063:20241023:074952.933 ******************************
+ v( ]" r, s! V" o- C$ s9 ~  2063:20241023:074952.933 using configuration file: /var/lib/zabbix-6-4-20/etc/zabbix_server.conf
, w3 p0 k* w0 k+ S3 A  2063:20241023:074952.938 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
  2063:20241023:074952.938 database is down: reconnecting in 10 seconds
  2063:20241023:075002.940 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
/ P9 N4 A2 e. h! {. a  2063:20241023:075002.941 database is down: reconnecting in 10 seconds
' ~' E' u% Z- g$ {, T8 j$ x  2063:20241023:075012.942 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
  2063:20241023:075012.943 database is down: reconnecting in 10 seconds
. j% c# G. P4 {  2063:20241023:075022.944 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
: v2 C  z9 O* E/ D  2063:20241023:075022.944 database is down: reconnecting in 10 seconds
  2063:20241023:075032.946 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
  2063:20241023:075032.946 database is down: reconnecting in 10 seconds
0 z6 ?" O& }  j6 }  2063:20241023:075042.948 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
  2063:20241023:075042.949 database is down: reconnecting in 10 seconds

admin

cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so:
1 G$ v4 D* f4 w2 ~; U
: v/ d, W) }4 o8 l' K4 }: \  d
+ j. z! H% @8 P% z5 ^3 ~mysql> alter user 'zabbix'@'localhost' identified with caching_sha2_password  by 'Zabbix123@';
  T3 l6 d, J. r, n$ u" E9 xQuery OK, 0 rows affected (0.02 sec)
% f5 ?. {2 w# Y
' H. j) U0 D/ [. ]mysql> flush privileges;
0 @0 V. `3 z! a) a; L7 @+ z+ fQuery OK, 0 rows affected (0.00 sec)
. w6 g* c& C- i% s7 A
$ t' S0 B" b1 E+ S% p9 X, G( b5 |5 Bmysql> alter user 'zabbix'@'localhost' identified with mysql_native_password  by 'Zabbix123@';
Query OK, 0 rows affected (0.00 sec)

  F; Y! t! R* S- {$ Bmysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

7 F# A. ?# Q- ^8 zmysql>
  G* F/ Y5 b4 N! m1 _9 [; F

admin

2164:20241023:081631.024 Starting Zabbix Server. Zabbix 6.4.20 (revision 114e4f42c15).
  2164:20241023:081631.025 ****** Enabled features ******
  2164:20241023:081631.025 SNMP monitoring:           YES
2 g2 ^* K7 j6 e6 c2 d: b  2164:20241023:081631.025 IPMI monitoring:            NO
) }7 a1 Z, u8 k) F  2164:20241023:081631.025 Web monitoring:             NO
  2164:20241023:081631.025 VMware monitoring:          NO
  2164:20241023:081631.025 SMTP authentication:        NO
& g) W: {3 Z4 Y: C4 O. v  2164:20241023:081631.026 ODBC:                       NO
% Z" t# `6 t7 Q3 O2 X  2164:20241023:081631.026 SSH support:                NO
  2164:20241023:081631.026 IPv6 support:               NO
  l3 \6 U3 L* x) M9 T  2164:20241023:081631.026 TLS support:                NO
  2164:20241023:081631.026 ******************************
; ]* @0 p8 }- J( @5 o, Y* {  D+ F  2164:20241023:081631.026 using configuration file: /var/lib/zabbix-6-4-20/etc/zabbix_server.conf
# D" W$ ?* o$ K; _  2164:20241023:081631.067 current database version (mandatory/optional): 06040000/06040036
6 N% @, R$ e/ A2 e1 K4 z, A" k  2164:20241023:081631.068 required mandatory version: 06040000
  2165:20241023:081631.118 starting HA manager
  2165:20241023:081631.141 HA manager started in active mode
  2164:20241023:081631.143 server #0 started [main process]
  2166:20241023:081631.144 server #1 started [service manager #1]
  2167:20241023:081631.145 server #2 started [configuration syncer #1]
, K- l9 G. Q% y  2168:20241023:081631.947 server #3 started [alert manager #1]
  2169:20241023:081631.948 server #4 started [alerter #1]
# g( U- t; E8 N9 [5 \  2170:20241023:081631.948 server #5 started [alerter #2]
, v/ l3 ~+ T. v2 a$ m' @  2171:20241023:081631.950 server #6 started [alerter #3]
; Z3 I0 b- C+ e/ ?  2173:20241023:081631.950 server #8 started [lld manager #1]
  2172:20241023:081631.951 server #7 started [preprocessing manager #1]
  2174:20241023:081631.951 server #9 started [lld worker #1]
$ w  v/ t7 y$ I  2175:20241023:081631.952 server #10 started [lld worker #2]
4 m5 x$ e2 V  J5 _" ~9 J  2177:20241023:081631.954 server #12 started [timer #1]
' d0 h6 f9 v! c# l+ ]% Z  2178:20241023:081631.956 server #13 started [http poller #1]
9 B. X' d! P% U1 _3 `  2179:20241023:081631.957 server #14 started [discoverer #1]
' w% b$ r2 P; y9 k$ |  2185:20241023:081631.961 server #17 started [history syncer #3]
  2186:20241023:081631.963 server #18 started [history syncer #4]
  ?6 M# x0 F" [4 d7 b4 h) ^, L  2187:20241023:081631.964 server #19 started [escalator #1]
  2188:20241023:081631.966 server #20 started [proxy poller #1]
  @) {1 ]/ |. G( Q  2183:20241023:081631.967 server #16 started [history syncer #2]
0 \2 o" s- n  v( |  2192:20241023:081631.967 server #23 started [poller #1]
  2176:20241023:081631.968 server #11 started [housekeeper #1]
  2194:20241023:081631.970 server #24 started [poller #2]
. t8 @8 Y. Q) w1 V  2195:20241023:081631.972 server #25 started [poller #3]
  2198:20241023:081631.975 server #27 started [poller #5]
/ {7 K( Q0 [: u; d* S0 \, W  2189:20241023:081631.975 server #21 started [self-monitoring #1]
  2202:20241023:081631.977 server #29 started [trapper #1]
9 p6 P+ i: R) v2 v6 o/ S  2204:20241023:081631.978 server #31 started [trapper #3]
- l+ ^: S, F# k2 r  2207:20241023:081631.980 server #34 started [icmp pinger #1]
  2182:20241023:081631.981 server #15 started [history syncer #1]
  2191:20241023:081631.982 server #22 started [task manager #1]
  2208:20241023:081631.982 server #35 started [alert syncer #1]
( n4 E0 X  E! U0 a: z: k; ^  2201:20241023:081631.983 server #28 started [unreachable poller #1]
  2209:20241023:081631.984 server #36 started [history poller #1]
  2203:20241023:081631.987 server #30 started [trapper #2]
+ @' S! O  X5 A" U  2215:20241023:081631.987 server #38 started [history poller #3]
  2206:20241023:081631.988 server #33 started [trapper #5]
/ i& i- M& J; o, [* ~- {* r" Q  2219:20241023:081631.989 server #40 started [history poller #5]
$ O; ]" I1 H  |5 A6 G9 i  2218:20241023:081631.990 server #39 started [history poller #4]
  2205:20241023:081631.990 server #32 started [trapper #4]
8 p- C! a. d- b3 Z) ]' G, P  2221:20241023:081631.992 server #42 started [trigger housekeeper #1]
  2197:20241023:081631.993 server #26 started [poller #4]
  2210:20241023:081631.994 server #37 started [history poller #2]
  2222:20241023:081631.999 server #43 started [odbc poller #1]
  2220:20241023:081632.002 server #41 started [availability manager #1]
  2172:20241023:081632.006 [1] thread started [preprocessing worker #1]
  2172:20241023:081632.008 [2] thread started [preprocessing worker #2]
( C% f  `+ I5 q" ~  2172:20241023:081632.009 [3] thread started [preprocessing worker #3]
7 I. M( L- O. L  n  2194:20241023:081638.016 enabling Zabbix agent checks on host "Zabbix server": interface became available
  2185:20241023:081641.010 item "Zabbix server:zabbix[process,ipmi poller,avg,busy]" became not supported: No "ipmi poller" processes started.
7 K" H$ I7 ?1 y+ o( |, x. t  2186:20241023:081642.015 item "Zabbix server:zabbix[process,java poller,avg,busy]" became not supported: No "java poller" processes started.
  2186:20241023:081647.034 item "Zabbix server:zabbix[process,snmp trapper,avg,busy]" became not supported: No "snmp trapper" processes started.
  2186:20241023:081647.034 item "Zabbix server:zabbix[process,ipmi manager,avg,busy]" became not supported: No "ipmi manager" processes started.
  2186:20241023:081647.035 item "Zabbix server:zabbix[connector_queue]" became not supported: connector is not initialized: please check "StartConnectors" configuration parameter
& z& k* d* x3 |1 v  g  2185:20241023:081648.035 item "Zabbix server:zabbix[process,vmware collector,avg,busy]" became not supported: No "vmware collector" processes started.
  2185:20241023:081648.035 item "Zabbix server:zabbix[process,connector manager,avg,busy]" became not supported: No "connector manager" processes started.
0 |9 Q/ Y& C8 F. M/ t  2185:20241023:081649.049 item "Zabbix server:zabbix[process,connector worker,avg,busy]" became not supported: No "connector worker" processes started.
  2182:20241023:081655.013 item "Zabbix server:zabbix[vmware,buffer,pused]" became not supported: No "vmware collector" processes started.
2 L) ]+ U; j% l" g  2182:20241023:081658.033 item "Zabbix server:zabbix[process,report writer,avg,busy]" became not supported: No "report writer" processes started.
9 H' U& T% p% I; J, E* r" U2 G  2183:20241023:081659.038 item "Zabbix server:zabbix[process,report manager,avg,busy]" became not supported: No "report manager" processes started.