[monit] MySQL: connection failed

[Ramon Tayag]

Hi all,

I'm trying to monit MySQL now on CentOS, but I've used the exact same
config file for mysql in another server (Ubuntu) and it works fine.

check process mysql with pidfile /var/run/mysqld/mysqld.pid
   group database
   start program = "/etc/init.d/mysqld start"
   stop program = "/etc/init.d/mysqld stop"
   if failed host 127.0.0.1 port 3306 then restart
   if 5 restarts within 5 cycles then timeout

But I'm unable to monitor it (connection failed to 127.0.0.1:3306
[DEFAULT via TCP]), and I don't know why. I also tried the same config
except I changed 127.0.0.1 but changed it to localhost, but it still
fails.

What should I do?

Thanks,
Ramon Tayag