connection to database 'zabbix' failed:

最新推荐文章于 2024-04-14 15:05:41 发布
原创 最新推荐文章于 2024-04-14 15:05:41 发布 · 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服务。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

在配置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...
[Z3001] connection to database 'zabbix' failed: [2003] Can't connect to MySQL server on 'x.x.x.x' (1...
weixin_30551947的博客
12-29 4106
　　公司用户逐渐增加，服务器的运行需要监控起来了。看到网上说服务器监控流行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 2084
[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 2732
通过看日志文件继续排查，通过如下指令找到安装zabbix时的日志文件所在。但是通过如下指令在服务器端查看zabbixserver是正常运行。大致意思是连接数据库失败。
zabbix运维：[Z3001] connection to database ‘zabbix‘ failed: [1045]
小梁的博客
01-21 5625
[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的报错内容。如果是配置错误，需要在/..
[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) ...
9864:20230526:220207.863 database is down: reconnecting in 10 seconds 9864:20230526:220217.875 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES) 9864:20230526:220217.875 database is down: reconnecting in 10 seconds 9864:20230526:220227.878 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES) 9864:20230526:220227.878 database is down: reconnecting in 10 second
05-27
GRANT ALL PRIVILEGES ON zabbix.* TO 'zabbix'@'localhost' IDENTIFIED BY '<password>'; FLUSH PRIVILEGES; ``` 3. 如果上述步骤都没有解决问题，您可以尝试重新启动 Zabbix 服务器和 MySQL 数据库，或者重启...
connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
04-28
这个错误提示表明使用用户名为 'zabbix'，密码为 YES 的用户无法连接到名为 'zabbix' 的数据库。这可能是由于以下原因导致的： 1. 用户名或密码错误。 2. 用户没有足够的权限访问该数据库。 3. 数据库不存在或者已...
connection to database 'zabbix' failed: [2002] Can't connect to local server through socket '/var/lib/mysql/mysql.sock
04-02
连接到数据库 'zabbix' 失败：[2002] 无法通过套接字 '/var/lib/mysql/mysql.sock' 连接到本地服务器。 这个错误通常表示无法通过指定的套接字路径连接到MySQL服务器。可能有几个原因导致这个问题： 1. MySQL...
connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
08-12
- *1* [zabbix启动报错connection to database ‘zabbixdb‘ failed: [2002]......](https://blog.youkuaiyun.com/ichen820/article/details/118053830)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630",...
zabbix启动报错:Connection to database 'xxx' failed解决方法
weixin_33909059的博客
07-28 1332
Zabbix 分布式系统监视系统 zabbix是一个基于WEB界面的提供分布式系统监视以及网络监视功能的企业级的开源解决方案。 zabbix能监视各种网络参数，保证服务器系统的安全运营；并提供灵活的通知机制以让系统管理员快速定位/解决存在的各种问题。     本文讲解的是zabbix无法启动报错:Connection to database 'xxx' failed: [1045] Acc...
zabbix连不上数据库
weixin_30374009的博客
07-24 1615
[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 563
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 8746
在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】connection to database 'zabbix' failed: [1045] Access denied for user 'root'@'localhost' (us...
weixin_30649641的博客
11-29 1308
前面安装的我就不说了，度娘上的很多； 关键是这个问题，网上的比较多，但是没有发现有用的； 问题：zabbix server is runing　　No 日志：/tmp/zabbix_server.log connection to database 'zabbix' failed: [1045] Access denied for user 'root'@'localhost' ...
记一次zabbix无法连接数据库问题_connection to database ‘zabbix‘ failed [1045] acc
2401_84281643的博客
04-14 1053
*深知大多数软件测试工程师，想要提升技能，往往是自己摸索成长或者是报班学习，但对于培训机构动则几千的学费，着实压力不小。**既有适合小白学习的零基础资料，也有适合3年以上经验的小伙伴深入学习提升的进阶课程，基本涵盖了95%以上软件测试开发知识点，真正体系化！**由于文件比较大，这里只是将部分目录大纲截图出来，每个节点里面都包含大厂面经、学习笔记、源码讲义、实战项目、讲解视频，并且后续会持续更新**$DB['DATABASE'] = 'zabbix的数据库名';查看php初始化配置是否一致。
zabbix连不上mysql_zabbix连不上数据库
weixin_29577659的博客
02-22 933
[root@localhost etc]# tail -f /var/log/zabbix_server.log1267:20130722:195451.493 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/lib/mys...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值