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...


应该是在配置的时候没有执行数据库zabbix用户的配置：
mysql> alter user 'zabbix'@'localhost' identified with mysql_native_password BY 'Zabbix23@';
Query OK, 0 rows affected (0.01 sec)
  b) z9 \9 l' o; ?$ w
6 C+ k/ W' ^! y3 v0 `5 C) c3 R: imysql> flush privilges;
! U6 f* ]# u0 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
# u, M; P, p1 Imysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
# y) @+ d( l; P  i" e
* \8 a  w) G! d. T4 pmysql>
# Q. V) H: ?) \. U' Y$ m6 s1 f( [
$ |1 V$ e" C/ y: J4 l9 G( z' @  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...


& e0 L) R" F0 T& {: \
: r: V& M7 s6 O. e5 _  y
  2063:20241023:074952.930 Starting Zabbix Server. Zabbix 6.4.20 (revision 114e4f42c15).
  2063:20241023:074952.931 ****** Enabled features ******
# f% J6 Q! Y; X1 ^+ ~  2063:20241023:074952.931 SNMP monitoring:           YES
  2063:20241023:074952.931 IPMI monitoring:            NO
4 o# ~; D' @$ a( x" p/ V7 }7 C  2063:20241023:074952.931 Web monitoring:             NO
6 D2 ]% [. e1 m3 q. S1 Q" S  2063:20241023:074952.932 VMware monitoring:          NO
( b% |" m3 b  W- b. J: d  2063:20241023:074952.932 SMTP authentication:        NO
, Z4 u1 P+ n) o3 C  2063:20241023:074952.932 ODBC:                       NO
2 C! O9 A# J& ~6 G& W1 T7 p5 k  2063:20241023:074952.932 SSH support:                NO
) Q1 c$ }% w/ H  2063:20241023:074952.932 IPv6 support:               NO
8 G9 h, Y. r9 e. M4 F% p. v  2063:20241023:074952.932 TLS support:                NO
  2063:20241023:074952.933 ******************************
% q& j# k+ |3 r2 s2 ?# K  2063:20241023:074952.933 using configuration file: /var/lib/zabbix-6-4-20/etc/zabbix_server.conf
  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
% [$ k( `& _& V: b3 f1 ?  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
  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
# b# v/ J) r/ y8 I- M  2063:20241023:075022.944 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
( y$ G4 E) B: t  2063:20241023:075022.944 database is down: reconnecting in 10 seconds
7 F' J( j9 R9 u  S) E) I* x' U  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
/ ~7 d8 f1 l2 n: I/ h  2063:20241023:075042.948 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
3 _' z. n3 V7 |0 d) s1 \7 l3 @  2063:20241023:075042.949 database is down: reconnecting in 10 seconds

* x3 t7 V0 x# t0 b& }5 g

admin

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

. N. T/ B2 T- F7 e. [% b  u0 K! N) s
# F/ Q5 D4 M: \" xmysql> alter user 'zabbix'@'localhost' identified with caching_sha2_password  by 'Zabbix123@';
Query OK, 0 rows affected (0.02 sec)
0 X! M9 b! p9 `) S  v9 n$ U
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> alter user 'zabbix'@'localhost' identified with mysql_native_password  by 'Zabbix123@';
Query OK, 0 rows affected (0.00 sec)

" w  A9 \; D" _$ T0 fmysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

  i6 D1 d5 _( c# t9 s* \* bmysql>

admin

2164:20241023:081631.024 Starting Zabbix Server. Zabbix 6.4.20 (revision 114e4f42c15).
. I7 Q3 S6 [. c- \  2164:20241023:081631.025 ****** Enabled features ******
* x1 g- H, w) g! z' [0 g# ?. l  2164:20241023:081631.025 SNMP monitoring:           YES
  2164:20241023:081631.025 IPMI monitoring:            NO
$ S2 Y! N5 p- C2 V2 y  2164:20241023:081631.025 Web monitoring:             NO
  2164:20241023:081631.025 VMware monitoring:          NO
, r0 f9 X8 k7 N  2164:20241023:081631.025 SMTP authentication:        NO
  2164:20241023:081631.026 ODBC:                       NO
) p" m7 i' t% A) Q, K8 U: X  2164:20241023:081631.026 SSH support:                NO
0 B" s- W6 V+ h: r( @0 D7 I  2164:20241023:081631.026 IPv6 support:               NO
  2164:20241023:081631.026 TLS support:                NO
5 a. ~0 y& H( q  2164:20241023:081631.026 ******************************
  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
3 d7 p# R; o3 z, x% g: D  2164:20241023:081631.068 required mandatory version: 06040000
  2165:20241023:081631.118 starting HA manager
' C; W; S- |" {9 @, e3 J5 o6 o% {  2165:20241023:081631.141 HA manager started in active mode
6 O# f+ v% G6 b( y  2164:20241023:081631.143 server #0 started [main process]
  2166:20241023:081631.144 server #1 started [service manager #1]
3 u) }& ]5 c6 d7 b6 ^8 W  2167:20241023:081631.145 server #2 started [configuration syncer #1]
  D1 Z1 F6 L; f# x, \, J7 [  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]
1 M" B5 C1 O6 D9 i% D0 [4 V  2171:20241023:081631.950 server #6 started [alerter #3]
0 I1 z2 w; x1 g: n5 j# f  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]
" ?) s  t# W3 R  s4 i8 Y  2175:20241023:081631.952 server #10 started [lld worker #2]
  2177:20241023:081631.954 server #12 started [timer #1]
3 T. R" G8 M7 e9 H% C  2178:20241023:081631.956 server #13 started [http poller #1]
" G3 f: M" l: v, W* c; ~5 z/ k  2179:20241023:081631.957 server #14 started [discoverer #1]
  2185:20241023:081631.961 server #17 started [history syncer #3]
7 W, H& j# V& p  2186:20241023:081631.963 server #18 started [history syncer #4]
, W9 q$ V! e- U' r  2187:20241023:081631.964 server #19 started [escalator #1]
  2188:20241023:081631.966 server #20 started [proxy poller #1]
  2183:20241023:081631.967 server #16 started [history syncer #2]
3 F8 i& L3 J+ S( K( B) ?, W  2192:20241023:081631.967 server #23 started [poller #1]
1 R+ w  I, F9 M5 g- ~  2176:20241023:081631.968 server #11 started [housekeeper #1]
5 N; V8 B  M" i/ }( K  2194:20241023:081631.970 server #24 started [poller #2]
* @% r3 e, ]8 M7 |3 O  2195:20241023:081631.972 server #25 started [poller #3]
; U0 m. d0 [3 O) P  2198:20241023:081631.975 server #27 started [poller #5]
  2189:20241023:081631.975 server #21 started [self-monitoring #1]
, v  F3 m3 p; q) C4 d6 w  d3 l  2202:20241023:081631.977 server #29 started [trapper #1]
  2204:20241023:081631.978 server #31 started [trapper #3]
6 P. d2 w9 g  P8 b2 r" y" h  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]
+ R+ c2 A2 L( U2 W  }  2201:20241023:081631.983 server #28 started [unreachable poller #1]
% d! _$ Z, h* b$ h4 }& T6 |  v, r  2209:20241023:081631.984 server #36 started [history poller #1]
  2203:20241023:081631.987 server #30 started [trapper #2]
  2215:20241023:081631.987 server #38 started [history poller #3]
* B+ S, S5 @. w- \, ~# T: z  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]
+ \2 r7 W6 K1 p6 ~- v, A  2205:20241023:081631.990 server #32 started [trapper #4]
6 ?; L: k* Y% s: K3 F  2221:20241023:081631.992 server #42 started [trigger housekeeper #1]
6 A0 s5 F0 ?# M) F  2197:20241023:081631.993 server #26 started [poller #4]
  2210:20241023:081631.994 server #37 started [history poller #2]
" i* H6 I. T% H, r3 E. m, y  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]
! W8 t# U0 n8 {4 f! Z  2172:20241023:081632.009 [3] thread started [preprocessing worker #3]
  H4 R3 @4 A7 m% J  a: }, Q  2194:20241023:081638.016 enabling Zabbix agent checks on host "Zabbix server": interface became available
7 J) |* l) r6 m* k  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.
8 N+ A* h& W9 r% |8 |% Y  2186:20241023:081647.034 item "Zabbix server:zabbix[process,ipmi manager,avg,busy]" became not supported: No "ipmi manager" processes started.
% l% F# T6 V9 q# Y  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.
2 e# F) k" D- z, Q& h  2185:20241023:081648.035 item "Zabbix server:zabbix[process,connector manager,avg,busy]" became not supported: No "connector manager" processes started.
  2185:20241023:081649.049 item "Zabbix server:zabbix[process,connector worker,avg,busy]" became not supported: No "connector worker" processes started.
0 y0 L: }2 m" K' Y' R: q  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.