I have some databases on my shared web server. It was all fine around 45 days back when my website is shifted to another server, all my data is shifted including databases. Now I cannot connect to my MySQL databases via external software (Visual Studio, Workbench etc). I can successfully connect to my databases via MyPHPAdmin provided to me via cpanel. The desktop applications are showing the following errors:
By reading some other questions on internet, I come to the point that it might be the firewall problem on webserver, it might block MySql default port 3306. How can I go into the firewall of my webserver and allow my port, (if it is a real problem)? I am using the default port of MySQL databases ie. 3306, I have already made my databases access globally by putting '%' in the remote access IP address.