connection to database 'zabbix' failed:

解决Zabbix 10051端口缺失问题
最新推荐文章于 2025-08-01 16:07:58 发布
原创 最新推荐文章于 2025-08-01 16:07:58 发布 · 8.7k 阅读 · 1 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#zabbix #database #connection #mysql

本文介绍了在配置LNMP+zabbix过程中遇到的zabbix_server服务启动后10051端口缺失的问题及解决办法。通过检查日志，发现与mysql.sock链接相关，并提供了两种解决方案：创建mysql.sock链接重启数据库服务或修改zabbix_server.conf中的mysql.sock配置重启zabbix_server服务。

在配置LNMP+zabbix时，发现zabbix_server服务可以启动，但是没有10051这个端口。查看日志，报错如下：


发现日志链接不上：


查找这个文件所在的位置：

查找这个文件

解决方法有两种：

（一）创建mysql.sock链接


重启数据库服务


（二）修改zabbix_server.conf中的mysql.sock配置


重启zabbix_server服务



一次zabbix连接不上mysql数据库的经历
huangbaokang的博客
02-27 1万+
使用sqlyog连接mysql数据库，是可以连接成功的，但是zabbix网页端图形界面就是连接不上，报错信息如下： 折腾了好久，想查看下zabbix_server的日志zabbix_server.conf，在zabbix_server的配置文件中找到了，默认配置文件如果没有修改，是如下 LogFile=/tmp/zabbix_server.log 在日志文件中查看到如下报错信息： 123089...
zabbix 报错
热心市民王先生
06-04 1153
1、启动 zabbix，ps aux |grep zabbix 发现没有 zabbix_server。 # cat /var/log/zabbix/zabbix_server.log   4720:20170331:024448.126 [Z3001] connection to database 'zabbix' failed: [1044] Access denied for user
[Z3001] connection to database 'zabbix' failed: [2003] Can't connect to MySQL server on 'x.x.x.x' (1...
weixin_30551947的博客
12-29 4125
　　公司用户逐渐增加，服务器的运行需要监控起来了。看到网上说服务器监控流行Zabbix，就摸索着安装试用下。 　　安装是按照官网文档来的，地址：https://www.zabbix.com/documentation/4.0/zh/manual/installation/install_from_packages/rhel_centos。 　　按照步骤执行到启动 Zabbix server 进...
[Z3001] connection to database ‘zabbix‘ failed: [1045] Access denied for user
T_Y_F_的博客
05-14 2218
[Z3001] connection to database 'zabbix' failed: [1045] Access denied for user
[Z3001] connection to database ‘zabbix‘ failed: [1045] Access denied for user ‘zabbix‘@‘localhost‘
shnu_cdk的博客
09-13 2963
通过看日志文件继续排查，通过如下指令找到安装zabbix时的日志文件所在。但是通过如下指令在服务器端查看zabbixserver是正常运行。大致意思是连接数据库失败。
[Z3001] connection to database ‘zabbix‘ failed: [2059] Authentication plugin ‘caching_sha2_password‘
qq_47800859的博客
02-09 1918
[Z3001] connection to database 'zabbix' failed: [2059] Authentication plugin 'caching_sha2_password'
96424:20251015:105609.796 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO) 96424:20251015:105609.796 database is down: reconnecting in 10 seconds 96424:20251015:105619.801 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO) 96424:20251015:105619.801 database is down: reconnecting in 10 seconds 96424:20251015:105629.804 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO) 96424:20251015:105629.805 database is down: reconnecting in 10 seconds 96424:20251015:105639.806 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO) 96424:20251015:105639.806 database is down: reconnecting in 10 seconds 96424:20251015:105649.810 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO)
最新发布
10-16
GRANT ALL PRIVILEGES ON zabbix.* TO 'zabbix'@'localhost'; FLUSH PRIVILEGES; ``` #### 检查主机名和 IP 地址 确保 `zabbix` 用户的主机名部分配置正确。有时，使用 `localhost` 可能会有解析问题，可尝试使用...
怎么解决 root@web-server:/home/zdh# tail -f /var/log/zabbix/zabbix_server.log 1183:20251015:110400.892 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO) 1183:20251015:110400.892 database is down: reconnecting in 10 seconds 1183:20251015:110410.893 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO) 1183:20251015:110410.894 database is down: reconnecting in 10 seconds 1183:20251015:110420.895 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO) 1183:20251015:110420.895 database is down: reconnecting in 10 seconds 1183:20251015:110430.897 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO) 1183:20251015:110430.897 database is down: reconnecting in 10 seconds 1183:20251015:110440.899 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO) 1183:20251015:110440.899 database is down: reconnecting in 10 seconds
10-16
GRANT ALL PRIVILEGES ON zabbix.* TO 'zabbix'@'localhost'; FLUSH PRIVILEGES; ``` 上述语句将 `zabbix` 用户对 `zabbix` 数据库的所有权限授予给了该用户。 ### 4. 检查主机限制 确认 `zabbix` 用户是否被允许从...
[root@localhost ~]# vi /var/log/zabbix/zabbix_server.log 29773:20250725:145659.307 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO) 29773:20250725:145659.307 database is down: reconnecting in 10 seconds 29773:20250725:145709.308 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO) 29773:20250725:145709.308 database is down: reconnecting in 10 seconds 29773:20250725:145719.309 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO) 29773:20250725:145719.309 database is down: reconnecting in 10 seconds 29773:20250725:145729.310 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO) 29773:20250725:145729.310 database is down: reconnecting in 10 seconds 29773:20250725:145739.310 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 29773:20250725:145739.310 database is down: reconnecting in 10 seconds 29773:20250725:145749.311 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO) 29773:20250725:145749.311 database is down: reconnecting in 10 seconds 29773:20250725:145752.039 Got signal [signal:15(SIGTERM),sender_pid:30435,sender_uid:0,reason:0]. Exiting ... 29773:20250725:145752.040 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO) 29773:20250725:145752.040 Cannot connect to the database. Exiting... 30441:20250725:145752.049 Starting Zabbix Server. Zabbix 4.0.50 (revision c40ad3289ad). 30441:20250725:145752.050 ****** Enabled features ****** 30441:20250725:145752.050 SNMP monitoring: YES 30441:20250725:145752.050 IPMI monitoring: YES 30441:20250725:145752.050 Web monitoring: YES 30441:20250725:145752.050 VMware monitoring: YES 30441:20250725:145752.050 SMTP authentication: YES 30441:20250725:145752.050 Jabber notifications: YES 30441:20250725:145752.050 Ez Texting notifications: YES 30441:20250725:145752.050 ODBC: YES 30441:20250725:145752.050 SSH support: YES 30441:20250725:145752.050 IPv6 support: YES 30441:20250725:145752.050 TLS support: YES 30441:20250725:145752.050 ****************************** 30441:20250725:145752.050 using configuration file: /etc/zabbix/zabbix_server.conf 30441:20250725:145752.052 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO) 30441:20250725:145752.052 database is down: reconnecting in 10 seconds 30441:20250725:145802.053 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO) 30441:20250725:145802.053 database is down: reconnecting in 10 seconds 30441:20250725:145812.053 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO) 30441:20250725:145812.054 database is down: reconnecting in 10 seconds 30441:20250725:145822.055 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO) 30441:20250725:145822.055 database is down: reconnecting in 10 seconds 30441:20250725:145832.056 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO) 30441:20250725:145832.056 database is down: reconnecting in 10 seconds 30441:20250725:145842.057 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO) 30441:20250725:145842.057 database is down: reconnecting in 10 seconds 30441:20250725:145852.058 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO) 30441:20250725:145852.058 database is down: reconnecting in 10 seconds
07-26
- [^1]: 报错信息一表示Zabbix服务不能用/var/lib/mysql/mysql.sock 成功连接数据库 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES) ...
93888:20250617:204114.616 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 93888:20250617:204114.616 database is down: reconnecting in 10 seconds 93888:20250617:204124.616 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 93888:20250617:204124.617 database is down: reconnecting in 10 seconds 93888:20250617:204134.618 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 93888:20250617:204134.618 database is down: reconnecting in 10 seconds
06-18
您遇到的错误 `[Z3001] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'` 表明Zabbix服务器无法通过MySQL套接字文件连接到数据库。以下是系统化的解决方案： #### 1. **...
zabbix运维：[Z3001] connection to database ‘zabbix‘ failed: [1045]
小梁的博客
01-21 5678
[Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO) 检查/usr/local/etc/zabbix_server.conf中口令是否配置正确 配置后要关闭zabbix进程重新启动。 zabbix server报错,需要在/tmp下检查zabbix_server.log的报错内容。如果是配置错误，需要在/..
zabbix启动报错:Connection to database 'xxx' failed解决方法
weixin_33909059的博客
07-28 1369
Zabbix 分布式系统监视系统 zabbix是一个基于WEB界面的提供分布式系统监视以及网络监视功能的企业级的开源解决方案。 zabbix能监视各种网络参数，保证服务器系统的安全运营；并提供灵活的通知机制以让系统管理员快速定位/解决存在的各种问题。     本文讲解的是zabbix无法启动报错:Connection to database 'xxx' failed: [1045] Acc...
启动zabbix-server报错“[Z3001] connection to database 'zabbix' failed: [0] received invalid response to S
昊鼎王五的博客
09-12 8271
启动zabbix-server报错“[Z3001] connection to database ‘zabbix’ failed: [0] received invalid response to SSL negotiation: J” 所在机器：centos7 1.报错场景： 启动zabbix-server,失败，查看日志 “[Z3001] connection to datab...
zabbix连不上数据库
weixin_30374009的博客
07-24 1652
[root@localhost etc]# tail -f /var/log/zabbix_server.log 1267:20130722:195451.493 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/lib/...
Zabbix Cannot connect to the database
热门推荐
zdl244的博客
03-30 1万+
zabbix在图形安装界面报如下错误： 原因是php页面文件conf目录下缺少一个数据库配置文件（zabbix.conf.php）： 解决办法： [root@zabbix ~]# cd /usr/share/nginx/html/conf    #进入网页根目录下（或者用find搜索zabbix.conf.php.example文件） [root@zabbix...
connetcion to database 'zabbix' failed: can't connect to local MYSQL server through socket '/var/lib
qq_42388880的博客
09-21 583
zabbix创建zabbix专门的数据库时，zabbix_server启动后， ps aux|grep zabbix 查看不出进程。 查看报错日志： tailf /var/log/zabbix/zabbix_server.log 提示: connetcion to database ‘zabbix’ failed: can’t connect to local MYSQL server throu...
[zabbix] Cannot connect to the database.Error connecting to database: Can’t connect to local MySQL s
万万没想到
04-06 8878
在web端安装zabbix时报错：Cannot connect to the database. Error connecting to database: Can’t connect to localMySQLserver through socket ‘/var/lib/mysql/mysql.sock’ (2) 如下图： 问题出现原因： 可能是你在安装MySQL的时候是自己编译安装的并且自定义了安装位置和配置文件储存位置导致的，所以/mysql/mysql.sock文件根本不在/var/..
zabbix错误集一：connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost
qq_29684215的博客
04-13 1万+
zabbix错误提示： connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO) 50111:20200412:050649.356 database is down: reconnecting in 10 seconds 解决...
ZABBIX 7.0安装报错[Z3001] connection to database ‘zabbix‘ failed: [1045] Access denied for user
Q先生
08-01 405
官方文档要求的是mysql,而我用的是mariadb-3:10.3.39,抱着死吗当活马医的心态更好数据库。安装完zabbix和mariadb后发现,zabbix-server一直在报错.反正就是反复的查权限,selinux,firewalld。好了,由于自己的随性浪费了5个小时.所以生产中操作还是需要根据官方文档来.配置文件中DBPassword=后面的密码必须加’'否则就报错。也算zabbix 7.0部署遇到的一个不大不小的坑吧。此时登录正常,那么显然授权和密码都是对的.这里就简单的说下当时的思路.
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值