mysql 10051_Zabix的10051端口无法启动如何解决？

启动zabbix是显示启动成功，查看端口，却发现没有10051端口

1、查看zabbix的日志

[root@bogon ldap]# cat /tmp/zabbix_server.log

‘/var/lib/mysql/mysql.sock’ (2)

2848:20181204:084007.165 database is down: reconnecting in 10 seconds

2848:20181204:084017.167 [Z3001] connection to database ‘zabbix’ failed: [2002] Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)

2848:20181204:084017.167 database is down: reconnecting in 10 seconds

看到没有连接上mysql数据库

2、修改zabbix的配置文件 zabbix_server.conf

找到 #DBSocket= 去掉前面的＃注释，改成 DBSocket=/tmp/mysql.sock

sed -i ‘s/# DBSocket=/DBSocket=\/tmp\/mysql.sock/g’ /usr/local/zabbix/etc/zabbix_server.conf

3、重启zabbbix 解决

/etc/init.d/zabbix_server stop && /etc/init.d/zabbix_server start

4、再次查看日志

[root@bogon ldap]# cat /tmp/zabbix_server.log

9135:20181204:085433.351 using configuration file: /usr/local/zabbix/etc/zabbix_server.conf

9135:20181204:085433.358 [Z3001] connection to database ‘zabbix’ failed: [1045] Access denied for user ‘zabbix’@’localhost’ (using password: YES)

9135:20181204:085433.358 database is down: reconnecting in 10 seconds

9135:20181204:085443.360 [Z3001] connection to database ‘zabbix’ failed: [1045] Access denied for user ‘zabbix’@’localhost’ (using password: YES)

9135:20181204:085443.360 database is down: reconnecting in 10 seconds

9135:20181204:085453.361 [Z3001] connection to database ‘zabbix’ failed: [1045] Access denied for user ‘zabbix’@’localhost’ (using password: YES)

9135:20181204:085453.362 database is down: reconnecting in 10 seconds

上面原因是zabbix的配置文件里面连接mysql数据库的密码写错了，改正重启zabxix_server即可

[root@bogon ~]# vi /usr/local/zabbix/etc/zabbix_server.conf

DBPassword=zabbix@123