I get mysql connection error when I use MySQL App Template.
Thais is error what I got :
11940:20160126:164832.709 zbx_popen(): executing script
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
and this is my userparameter_mysql.conf
and that is piece of zabbix_agentd.conf
One more file which I was setup in /var/lib/zabbix/ is .my.cnf
[PS : I used root as mysql user. I can't login in mysql with zabbix user from other host. Willing to get any help also about mysql privileges.]
Thais is error what I got :
11940:20160126:164832.709 zbx_popen(): executing script
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
and this is my userparameter_mysql.conf
Code:
11940:20160126:164832.709 zbx_popen(): executing script mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
Code:
### Option: Include # You may include individual files or all files in a directory in the configuration file. # Installing Zabbix will create include directory in /usr/local/etc, unless modified during the compile time. # # Mandatory: no # Default: # Include= #Include=/etc/zabbix/zabbix_agentd.d Include=/etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf #Include=/etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf # Include=/usr/local/etc/zabbix_agentd.userparams.conf # Include=/usr/local/etc/zabbix_agentd.conf.d/
Code:
[mysql] user=root password=password [mysqladmin] user=root password=password