Monitoring

[dolphinuk]

I am a VPS (with cPanel/WHM) in the next few days and want use Hyperspin monitoring for: HTTP, HTTPS, POP3, SMTP and MySQL

Now the question is how do I monitor MySQL as if I remember from my last VPS, for security reasons I setup MySQL to only allow access via localhost. Now do I just open the MySQL port 3306 in the firewall and get Hyperspin to monitor port 3306, or do I need to do something else, if so could you point me in the right direction ?

The firewall should be CSF/LFD

 

[dolphinuk]

I have made a PHP script to pull data from mysql

 

[andren]

INow the question is how do I monitor MySQL as if I remember from my last VPS, for security reasons I setup MySQL to only allow access via localhost. Now do I just open the MySQL port 3306 in the firewall and get Hyperspin to monitor port 3306, or do I need to do something else, if so could you point me in the right direction ?

Monitor it indirectly by pulling a page (just a single word) out of a mysql db and display that on a page. Then check that page for content changes.