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...
! I& h" l% t/ w

& M9 W2 M9 {8 _% i; C应该是在配置的时候没有执行数据库zabbix用户的配置：
mysql> alter user 'zabbix'@'localhost' identified with mysql_native_password BY 'Zabbix23@';
+ K- I, o8 E3 U* \- L" qQuery OK, 0 rows affected (0.01 sec)

mysql> flush privilges;
1 x4 l0 a9 |$ m* `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)
, |2 G' X, @; Y9 g* s4 B& g1 V
. D' D% p. A' _0 pmysql>

1 K( q, V$ C+ ^, @2 {& c# W  ^  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
- B0 J8 H& S% U. M/ z# q& A- C2 H  2009:20241023:074318.691 Cannot connect to the database. Exiting...
/ }! L( N/ s* N4 S4 R% y6 E$ e3 a

, I1 u4 q5 \& P9 M) B9 }& e! L

  2063:20241023:074952.930 Starting Zabbix Server. Zabbix 6.4.20 (revision 114e4f42c15).
) w" j/ g  P. o) Y* e! F$ F- W  2063:20241023:074952.931 ****** Enabled features ******
  2063:20241023:074952.931 SNMP monitoring:           YES
; I4 _/ c4 V, c2 U; }  2063:20241023:074952.931 IPMI monitoring:            NO
  2063:20241023:074952.931 Web monitoring:             NO
  2063:20241023:074952.932 VMware monitoring:          NO
  2063:20241023:074952.932 SMTP authentication:        NO
  2063:20241023:074952.932 ODBC:                       NO
  2063:20241023:074952.932 SSH support:                NO
% |" Q7 }8 _8 V- c  2063:20241023:074952.932 IPv6 support:               NO
  2063:20241023:074952.932 TLS support:                NO
) E; n3 N3 F, E/ W  2063:20241023:074952.933 ******************************
) ?$ S/ |! M9 e) I, A* y7 u; X  2063:20241023:074952.933 using configuration file: /var/lib/zabbix-6-4-20/etc/zabbix_server.conf
8 M1 ~, x- Z: w  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
$ E& j5 D6 N( P0 Y1 t  2063:20241023:075002.940 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
( E  z% u: {' Q) {1 ]/ ]$ {' l  2063:20241023:075002.941 database is down: reconnecting in 10 seconds
. Z, M; u  T) T: `2 e) B  2063:20241023:075012.942 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
3 Y5 [) \% \! o  2063:20241023:075012.943 database is down: reconnecting in 10 seconds
) U2 n* {- `' T& \% l  2063:20241023:075022.944 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
4 K9 O2 A" U5 b: V) h9 v9 V  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)
! v6 d6 u; g% r' L  2063:20241023:075032.946 database is down: reconnecting in 10 seconds
1 P; S5 O( Z5 c4 V  2063:20241023:075042.948 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
8 a7 f) q7 A# H. t  2063:20241023:075042.949 database is down: reconnecting in 10 seconds

admin

cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so:


: ~7 W9 L8 u! R  G9 n3 Umysql> alter user 'zabbix'@'localhost' identified with caching_sha2_password  by 'Zabbix123@';
Query OK, 0 rows affected (0.02 sec)

0 S* w* l/ s  Z! Mmysql> flush privileges;
; j0 _0 d! G! F1 q% b; RQuery OK, 0 rows affected (0.00 sec)
* _, U6 @  c9 P: |- m5 J; o" \
mysql> alter user 'zabbix'@'localhost' identified with mysql_native_password  by 'Zabbix123@';
  H: \7 y+ I, G: U% d  h" DQuery OK, 0 rows affected (0.00 sec)
4 k1 [6 P3 K' {1 s5 F3 J
5 M# D; `0 @" N% M) Fmysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
8 V8 Y$ k. l3 e! ^7 W+ C4 j
mysql>
1 f5 r& W% Y2 O9 l" V7 G

admin

2164:20241023:081631.024 Starting Zabbix Server. Zabbix 6.4.20 (revision 114e4f42c15).
# l4 H) W' b& @0 c, I9 g  2164:20241023:081631.025 ****** Enabled features ******
$ j) P. f' v$ ?( Y  2164:20241023:081631.025 SNMP monitoring:           YES
  2164:20241023:081631.025 IPMI monitoring:            NO
7 n. l  K% M8 I  2164:20241023:081631.025 Web monitoring:             NO
& p5 x3 l, ]$ s5 _1 {- n+ ]  2164:20241023:081631.025 VMware monitoring:          NO
  2164:20241023:081631.025 SMTP authentication:        NO
  I9 `. R& v5 o, E( Q7 m" K  2164:20241023:081631.026 ODBC:                       NO
  2164:20241023:081631.026 SSH support:                NO
  2164:20241023:081631.026 IPv6 support:               NO
  2164:20241023:081631.026 TLS support:                NO
# y% w/ g. A  a- @$ G7 P8 E  2164:20241023:081631.026 ******************************
# m5 @* o( L9 ]- R# }) X! _' B  2164:20241023:081631.026 using configuration file: /var/lib/zabbix-6-4-20/etc/zabbix_server.conf
2 u5 W1 Z# z9 F  2164:20241023:081631.067 current database version (mandatory/optional): 06040000/06040036
7 E* ?4 i6 o- ]4 H  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
9 S: u, {5 y! o5 ?  2164:20241023:081631.143 server #0 started [main process]
: l5 N( P' k' B: B% \5 G  2166:20241023:081631.144 server #1 started [service manager #1]
2 |" Z/ y- ^- h2 h! C9 l  2167:20241023:081631.145 server #2 started [configuration syncer #1]
  2168:20241023:081631.947 server #3 started [alert manager #1]
  2169:20241023:081631.948 server #4 started [alerter #1]
  2170:20241023:081631.948 server #5 started [alerter #2]
( S$ L) }. z! W5 S3 I5 u  2171:20241023:081631.950 server #6 started [alerter #3]
  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]
  2175:20241023:081631.952 server #10 started [lld worker #2]
0 R$ P( N1 ]! y5 U2 H  2177:20241023:081631.954 server #12 started [timer #1]
- J$ p: T6 R# p7 o/ Y  2178:20241023:081631.956 server #13 started [http poller #1]
% z& q  T# g- a; C  2179:20241023:081631.957 server #14 started [discoverer #1]
! d6 v2 l( J- _- W  |% L  2185:20241023:081631.961 server #17 started [history syncer #3]
, H% T7 L7 K% n  2186:20241023:081631.963 server #18 started [history syncer #4]
  2187:20241023:081631.964 server #19 started [escalator #1]
  2188:20241023:081631.966 server #20 started [proxy poller #1]
3 f' M6 ^* p9 k% |  2183:20241023:081631.967 server #16 started [history syncer #2]
1 j$ [+ a/ Q$ F' E3 K  2192:20241023:081631.967 server #23 started [poller #1]
- K) M& f3 z4 {, v9 k$ T$ F  2176:20241023:081631.968 server #11 started [housekeeper #1]
  2194:20241023:081631.970 server #24 started [poller #2]
. ]4 M2 Q8 h  r$ G* s  2195:20241023:081631.972 server #25 started [poller #3]
  2198:20241023:081631.975 server #27 started [poller #5]
  2189:20241023:081631.975 server #21 started [self-monitoring #1]
  2202:20241023:081631.977 server #29 started [trapper #1]
9 I0 D% r( y/ u# K) [% D! n  2204:20241023:081631.978 server #31 started [trapper #3]
. ^1 I9 ?9 t9 [+ b6 F5 c+ k" s9 W7 [  2207:20241023:081631.980 server #34 started [icmp pinger #1]
' P' [- d3 T6 o1 b  2182:20241023:081631.981 server #15 started [history syncer #1]
  k% Y; h3 g! k  v" T5 p  2191:20241023:081631.982 server #22 started [task manager #1]
  2208:20241023:081631.982 server #35 started [alert syncer #1]
; L. K( t/ Y9 r1 x3 C8 V  2201:20241023:081631.983 server #28 started [unreachable poller #1]
  2209:20241023:081631.984 server #36 started [history poller #1]
8 {9 B2 I2 Q# L, t  2203:20241023:081631.987 server #30 started [trapper #2]
  2215:20241023:081631.987 server #38 started [history poller #3]
  2206:20241023:081631.988 server #33 started [trapper #5]
4 \( q" d8 o, i6 J' O/ v; m  2219:20241023:081631.989 server #40 started [history poller #5]
1 C) f+ v8 e" _6 O* |  2218:20241023:081631.990 server #39 started [history poller #4]
  2205:20241023:081631.990 server #32 started [trapper #4]
  2221:20241023:081631.992 server #42 started [trigger housekeeper #1]
) f# ^0 h* g, m0 x8 t5 Q  2197:20241023:081631.993 server #26 started [poller #4]
  2210:20241023:081631.994 server #37 started [history poller #2]
' R( ?9 W* X& A: y7 [: X' K6 {. f  2222:20241023:081631.999 server #43 started [odbc poller #1]
5 W) t1 ^& X, @9 u  2220:20241023:081632.002 server #41 started [availability manager #1]
" V9 H, o  c0 h. y: z$ D  2172:20241023:081632.006 [1] thread started [preprocessing worker #1]
# f9 Y8 n" _6 e5 \& u  2172:20241023:081632.008 [2] thread started [preprocessing worker #2]
  2172:20241023:081632.009 [3] thread started [preprocessing worker #3]
: U1 `, h: n2 p# Z' t( W9 q4 |  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.
$ z1 ^5 Z5 @5 f  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.
4 c) h1 N2 S* @  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
1 v2 e1 K. r. i1 h/ A% ^/ l  2185:20241023:081648.035 item "Zabbix server:zabbix[process,vmware collector,avg,busy]" became not supported: No "vmware collector" processes started.
  N: {6 x/ I; D% k, p  X% K  2185:20241023:081648.035 item "Zabbix server:zabbix[process,connector manager,avg,busy]" became not supported: No "connector manager" processes started.
! e* P5 l& }3 t  X0 ]9 H2 T  2185:20241023:081649.049 item "Zabbix server:zabbix[process,connector worker,avg,busy]" became not supported: No "connector worker" processes started.
6 O  Y' R4 ^* S3 D% a% K* J" D  2182:20241023:081655.013 item "Zabbix server:zabbix[vmware,buffer,pused]" became not supported: No "vmware collector" processes started.
  2182:20241023:081658.033 item "Zabbix server:zabbix[process,report writer,avg,busy]" became not supported: No "report writer" processes started.
  2183:20241023:081659.038 item "Zabbix server:zabbix[process,report manager,avg,busy]" became not supported: No "report manager" processes started.