I have opened port 3306 in Plesk Firewall so that I can remotely connect to my server to do off site backups.
I have a cron job on another machine that connects every 24 hours to do a complete mysql backup.
My problem is that Plesk Firewall keeps closing the mysql port. It seems to happen daily also.
The backup fails everyday and doing a nmap shows that the port is closed. When I click "Edit Firewall Configuration" and then "Accept" the port opens up again and backup works. I'm not sure how long it works until it fails.
It is strange because when I view the firewall configuration after it has reset, mysql still appears to be open but nmap shows it has been closed (or reset).
Any help would be greatly appreciated.