zabbix界面上无数据日志报错connection to database 'zabbix' failed:

admin

7580:20210917:145626.898 using configuration file: /etc/zabbix/zabbix_server.conf
0 f$ [  \- e* f: j# R+ l  7580:20210917:145626.903 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)
: _0 k% A$ a/ c  7580:20210917:145626.903 database is down: reconnecting in 10 seconds
* D6 s! F, a! {9 W! f' s* z* G  7580:20210917:145636.904 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)
8 w) ?+ [$ y5 B9 ^3 w  7580:20210917:145636.904 database is down: reconnecting in 10 seconds
  7580:20210917:145646.904 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)
; Y- i1 ]0 W8 m: q! M% [* V& J& S  7580:20210917:145646.905 database is down: reconnecting in 10 seconds
  7580:20210917:145656.905 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)
  7580:20210917:145656.905 database is down: reconnecting in 10 seconds
  7580:20210917:145706.906 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)
5 ?( t! m1 W" r: f% I0 h4 F8 A( G  7580:20210917:145706.907 database is down: reconnecting in 10 seconds
  7580:20210917:145716.907 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)
  7580:20210917:145716.907 database is down: reconnecting in 10 seconds
% W) T* _' W* T; j' ^2 I4 F  7580:20210917:145726.908 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)
* V4 E3 O1 I7 Q  7580:20210917:145726.908 database is down: reconnecting in 10 seconds
  7580:20210917:145736.910 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)
  7580:20210917:145736.910 database is down: reconnecting in 10 seconds
  
1 P7 e  C0 u* y& x/ g
日志一直报错，解决办法：
2 U9 r3 U6 n+ b# e- z! k

数据库添加权限：
; H9 R! h; r. ^, ^" U) rgrant ALL PRIVILEGES on zabbix.* to "zabbix"@"zabbix-monitor.novalocal" Identified by "zabbix";
. I" u. h1 i) Q1 ~. s5 j7 p! t8 [
( o1 r, G1 G7 v7 @2 |/ ]
! S1 m# G# ^4 H

admin

问题解决：
4 m' l) V$ T- I2 v如日志所示：
7580:20210917:150726.962 database connection re-established
  7580:20210917:150726.963 current database version (mandatory/optional): 03040000/03040007
- l, O! ?- E% ?( a6 Y0 M% u  7580:20210917:150726.963 required mandatory version: 03040000
/ w7 J9 Z7 w+ O  7580:20210917:150726.979 server #0 started [main process]
  7738:20210917:150726.980 server #1 started [configuration syncer #1]
8 x( x' a' u: @, G/ ]+ c  7739:20210917:150726.980 server #2 started [alerter #1]
  7740:20210917:150726.981 server #3 started [alerter #2]
9 O5 F3 ]- S7 Y  7741:20210917:150726.981 server #4 started [alerter #3]
7 x& r/ b, R& w- s& ?7 s  N  7742:20210917:150726.981 server #5 started [housekeeper #1]
0 n% V+ x4 W/ W4 G  x: W: J  7743:20210917:150726.982 server #6 started [timer #1]
4 X/ I( B) u9 L+ W. x" j/ ^( u6 U2 ]  7744:20210917:150726.982 server #7 started [http poller #1]
1 ^  O/ V' j( q! J2 W. a  7747:20210917:150726.983 server #8 started [discoverer #1]
% A' v. k3 Y+ `7 S+ C' F" g  7748:20210917:150726.984 server #9 started [history syncer #1]
" F. n/ @2 d! z* ?( I1 ?  7750:20210917:150726.985 server #10 started [history syncer #2]
  7751:20210917:150726.985 server #11 started [history syncer #3]
2 f& V0 {6 M+ W  7755:20210917:150726.986 server #13 started [escalator #1]
5 j" B9 t. C( }, r- Z  7753:20210917:150726.986 server #12 started [history syncer #4]
3 S* [  Y/ A& D, F: a# ~+ s. I( \  7756:20210917:150726.986 server #14 started [proxy poller #1]
" ^9 x. j, H; c/ Y  7759:20210917:150726.987 server #16 started [task manager #1]
- \: {' o0 b. ~" `* z  7760:20210917:150726.988 server #17 started [poller #1]
- q& W+ c9 A/ [. |% Z" b, O+ k  7765:20210917:150726.990 server #21 started [poller #5]
1 b7 j6 Q: S) O+ q- H  7762:20210917:150726.990 server #18 started [poller #2]
2 T* {5 s% L) m, m( ^* s3 |  7764:20210917:150726.990 server #20 started [poller #4]
  7768:20210917:150726.993 server #23 started [trapper #1]
7 ~- Z: F/ d3 \  K9 p  7770:20210917:150726.993 server #25 started [trapper #3]
  7771:20210917:150726.994 server #26 started [trapper #4]
- T+ ^6 j6 w' T( X2 l' G, K: n5 T# P  7774:20210917:150726.995 server #29 started [alert manager #1]
4 d6 ]7 ~5 ^6 {3 U9 J, x2 B  7769:20210917:150726.996 server #24 started [trapper #2]
: q: r$ [8 x, S+ ^" F7 n- x8 n6 B  7766:20210917:150726.997 server #22 started [unreachable poller #1]
/ K1 _: S. n  Y( k  7773:20210917:150726.997 server #28 started [icmp pinger #1]
) F" N; G4 R5 s& j2 H1 E6 o  7776:20210917:150726.997 server #30 started [preprocessing manager #1]
  7763:20210917:150726.998 server #19 started [poller #3]
  7757:20210917:150726.999 server #15 started [self-monitoring #1]
  7772:20210917:150726.999 server #27 started [trapper #5]
# C: {9 r6 k7 w, J& E3 Q  C0 V  7777:20210917:150727.093 server #31 started [preprocessing worker #1]
  C8 }3 L1 O; }! u7 h* v% J# ~  7778:20210917:150727.094 server #32 started [preprocessing worker #2]
* O& ~2 C! _+ e/ _+ P6 k  7779:20210917:150727.094 server #33 started [preprocessing worker #3]
5 o9 [% }! [) p  7760:20210917:150730.194 Zabbix agent item "system.users.num" on host "10.144.106.6" failed: first network error, wait for 15 seconds
$ m# T; Z, l3 c8 g3 b! \  7762:20210917:150744.196 Zabbix agent item "agent.ping" on host "10.144.108.9" failed: first network error, wait for 15 seconds
- X- R1 @! K4 n. Z  7766:20210917:150830.258 temporarily disabling Zabbix agent checks on host "10.144.106.6": host unavailable
# E: N2 w; X# X, ?  7770:20210917:150835.682 cannot send list of active checks to "10.144.108.9": host [zbbix-agent] not found
8 C" V& G1 D. d  l/ S# s  7766:20210917:150844.264 temporarily disabling Zabbix agent checks on host "10.144.108.9": host unavailable
! Q2 f0 S/ w0 l5 Q( G
/ \2 {! q' |$ `" I0 ]! r5 l