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- Y7 A6 i: |5 Q
  N7 V. O+ |4 ^# g; T6 R. ]6 \; B( R应该是在配置的时候没有执行数据库zabbix用户的配置：
- T' [; ]' d" Q$ w0 U; \1 }mysql> alter user 'zabbix'@'localhost' identified with mysql_native_password BY 'Zabbix23@';
Query OK, 0 rows affected (0.01 sec)
; i9 g4 I, R( y/ {& g9 }
7 H( J& ?% f8 pmysql> flush privilges;
  f' `: Q- ]9 ], _- SERROR 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
: j% m9 V/ y2 B7 ?mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
' a& v, P' c* H
mysql>
; O8 [9 m/ u* U6 }
/ g7 W5 g. W6 O9 A8 K+ I  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
# o. h. R0 c7 p" W& f5 T: g. h8 p  2009:20241023:074318.691 Cannot connect to the database. Exiting...
3 k' S3 r% j* Q
& ^" Q6 W8 x( n! U* Y/ t! e2 d
( E$ V. d" `# \- |1 M8 I

  2063:20241023:074952.930 Starting Zabbix Server. Zabbix 6.4.20 (revision 114e4f42c15).
; u1 b3 q0 I' H  2063:20241023:074952.931 ****** Enabled features ******
+ Z" x# I- \- {: A9 N8 V  2063:20241023:074952.931 SNMP monitoring:           YES
( s9 l' k+ u! N. s+ k, X; f. h  2063:20241023:074952.931 IPMI monitoring:            NO
9 m- d7 V- E5 k5 G  k7 G" J  2063:20241023:074952.931 Web monitoring:             NO
3 o" m, |6 y2 H. M4 J) w. ~) T- ~! Z  2063:20241023:074952.932 VMware monitoring:          NO
8 J  R9 q( Y  A/ _, {  2063:20241023:074952.932 SMTP authentication:        NO
" N, z( P5 v, b* P% w: K% p  2063:20241023:074952.932 ODBC:                       NO
  2063:20241023:074952.932 SSH support:                NO
  2063:20241023:074952.932 IPv6 support:               NO
9 s# z8 [, K1 O* J$ n: F  2063:20241023:074952.932 TLS support:                NO
  2063:20241023:074952.933 ******************************
2 \' S9 k* y7 e' f/ _/ p  2063:20241023:074952.933 using configuration file: /var/lib/zabbix-6-4-20/etc/zabbix_server.conf
: A3 `8 n  a9 h. Q& D: @# v  2063:20241023:074952.938 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
- I3 {3 O/ o, |  r2 ^* n  2063:20241023:074952.938 database is down: reconnecting in 10 seconds
6 r% [3 m' s7 G4 d+ y  2063:20241023:075002.940 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
  2063:20241023:075002.941 database is down: reconnecting in 10 seconds
; \* q; U+ }  c7 w+ b  2063:20241023:075012.942 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
! a4 X' U2 A5 k. w( `5 i7 U; c, b& [  2063:20241023:075012.943 database is down: reconnecting in 10 seconds
  2063:20241023:075022.944 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
  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
5 w1 L. w" ^1 ]$ M3 z2 |0 L  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

0 ~) A% l5 u" Z' s

admin

cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so:
; ~% Q2 V9 j% J) h% h9 t6 M

mysql> alter user 'zabbix'@'localhost' identified with caching_sha2_password  by 'Zabbix123@';
8 W3 G4 x/ [/ o& ?: s. S+ T6 xQuery OK, 0 rows affected (0.02 sec)
+ |/ L( B$ {/ X: [/ ?, V7 X5 S
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

1 G- z; t4 h$ Dmysql> alter user 'zabbix'@'localhost' identified with mysql_native_password  by 'Zabbix123@';
Query OK, 0 rows affected (0.00 sec)
8 n' m# U! Y& ^' x  B7 {
mysql> flush privileges;
) M9 Z; ~* x: SQuery OK, 0 rows affected (0.01 sec)

mysql>

admin

2164:20241023:081631.024 Starting Zabbix Server. Zabbix 6.4.20 (revision 114e4f42c15).
$ O/ K0 m3 Z% v2 j) e  2164:20241023:081631.025 ****** Enabled features ******
  2164:20241023:081631.025 SNMP monitoring:           YES
  2164:20241023:081631.025 IPMI monitoring:            NO
5 \" V0 g& c" S, c2 j  2164:20241023:081631.025 Web monitoring:             NO
/ d7 |' l9 v; x5 O+ ^0 [. T+ B  2164:20241023:081631.025 VMware monitoring:          NO
  2164:20241023:081631.025 SMTP authentication:        NO
# v3 l% k, h  ?/ `6 ]) a  2164:20241023:081631.026 ODBC:                       NO
  ]( B2 t! P0 n, E% w  2164:20241023:081631.026 SSH support:                NO
  2164:20241023:081631.026 IPv6 support:               NO
# ]" Z! H  `* I7 s  2164:20241023:081631.026 TLS support:                NO
  2164:20241023:081631.026 ******************************
6 o4 b) j6 s/ G8 ^/ f  2164:20241023:081631.026 using configuration file: /var/lib/zabbix-6-4-20/etc/zabbix_server.conf
  2164:20241023:081631.067 current database version (mandatory/optional): 06040000/06040036
5 t' q$ O* L5 W/ q% j  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]
/ j% Z) C3 F' C, \& @; _6 @8 p  2166:20241023:081631.144 server #1 started [service manager #1]
  2167:20241023:081631.145 server #2 started [configuration syncer #1]
' ~7 O3 i0 q9 r5 r* f% b  2168:20241023:081631.947 server #3 started [alert manager #1]
5 w& e$ J3 n9 e  W  2169:20241023:081631.948 server #4 started [alerter #1]
  2170:20241023:081631.948 server #5 started [alerter #2]
  2171:20241023:081631.950 server #6 started [alerter #3]
  2173:20241023:081631.950 server #8 started [lld manager #1]
& u! l6 l$ N( @  2172:20241023:081631.951 server #7 started [preprocessing manager #1]
) G' [7 E7 x  k$ P7 n) i  2174:20241023:081631.951 server #9 started [lld worker #1]
* p& i$ I) l9 V& r! r* z  b& h  2175:20241023:081631.952 server #10 started [lld worker #2]
  2177:20241023:081631.954 server #12 started [timer #1]
  2178:20241023:081631.956 server #13 started [http poller #1]
  2179:20241023:081631.957 server #14 started [discoverer #1]
7 Q: R$ y, o! G& i( X- i  r) R  2185:20241023:081631.961 server #17 started [history syncer #3]
  2186:20241023:081631.963 server #18 started [history syncer #4]
  2187:20241023:081631.964 server #19 started [escalator #1]
# Z8 g) N* V4 W- V' n  2188:20241023:081631.966 server #20 started [proxy poller #1]
+ X. W3 j/ z! h' s* @  2183:20241023:081631.967 server #16 started [history syncer #2]
* n! u+ A( k9 J1 M  2192:20241023:081631.967 server #23 started [poller #1]
! L+ n0 |( r9 q/ r  2176:20241023:081631.968 server #11 started [housekeeper #1]
) C/ m. X  x; h7 i+ M  2194:20241023:081631.970 server #24 started [poller #2]
" w" q8 b% N% I8 J! b5 N% [# u4 g) E  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]
  j* j- q% p/ h& \2 {0 ^  2202:20241023:081631.977 server #29 started [trapper #1]
  O  _3 x: R3 r$ U' ]& N  2204:20241023:081631.978 server #31 started [trapper #3]
  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]
2 @$ ~% J) \  n2 m; F; ^* n  2208:20241023:081631.982 server #35 started [alert syncer #1]
  2201:20241023:081631.983 server #28 started [unreachable poller #1]
! J( G9 M7 }0 V0 |. A  2209:20241023:081631.984 server #36 started [history poller #1]
! D, A/ `1 M2 ~& T9 g$ ~% `; p! W  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]
  2219:20241023:081631.989 server #40 started [history poller #5]
  2218:20241023:081631.990 server #39 started [history poller #4]
  2205:20241023:081631.990 server #32 started [trapper #4]
! {3 I4 V4 I; c0 U8 o! B  2221:20241023:081631.992 server #42 started [trigger housekeeper #1]
  2197:20241023:081631.993 server #26 started [poller #4]
5 y9 i* l$ Y8 m8 G( `1 o# \  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]
& _7 J$ h2 a5 d: s# N6 r  2172:20241023:081632.009 [3] thread started [preprocessing worker #3]
  2194:20241023:081638.016 enabling Zabbix agent checks on host "Zabbix server": interface became available
4 E3 R7 \$ M( O2 `  2185:20241023:081641.010 item "Zabbix server:zabbix[process,ipmi poller,avg,busy]" became not supported: No "ipmi poller" processes started.
  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.
9 Q9 I2 r' Y) I  z$ r' T  2186:20241023:081647.035 item "Zabbix server:zabbix[connector_queue]" became not supported: connector is not initialized: please check "StartConnectors" configuration parameter
  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.
% _& w) L# D& w3 r  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.
! u- }$ o  S2 ]& C2 |) O  2182:20241023:081658.033 item "Zabbix server:zabbix[process,report writer,avg,busy]" became not supported: No "report writer" processes started.
( k2 J: H- `6 v8 Z6 f1 G- S5 ]  2183:20241023:081659.038 item "Zabbix server:zabbix[process,report manager,avg,busy]" became not supported: No "report manager" processes started.