External Application connection to MySql Database

[Mark Lawrence]

I have a MySql database that I have defined on my cPanel page.  I have also added the IP of my home gateway to the internet as an Remote SQL connection.  I am developing a C# application to be able to rapidly enter data into a table on my MySql database.  I have a local MySql user assigned to the data and I provide a connection to my hawkhost domain IP, port as 3306, the database name, the MySql user and password I have created, and attempt to connect, however I get an application error "Unable to connect to any of the specified MySQL hosts".  Any idea on how I can get this connection error corrected?

Thanks!

[Brian]

18 hours ago, Mark Lawrence said:

I have a MySql database that I have defined on my cPanel page.  I have also added the IP of my home gateway to the internet as an Remote SQL connection.  I am developing a C# application to be able to rapidly enter data into a table on my MySql database.  I have a local MySql user assigned to the data and I provide a connection to my hawkhost domain IP, port as 3306, the database name, the MySql user and password I have created, and attempt to connect, however I get an application error "Unable to connect to any of the specified MySQL hosts".  Any idea on how I can get this connection error corrected?

Thanks!

In addition to whitelisting the IP through cPanel as you've done, our support team will also need to whitelist the remote IP(s) you're using to connect through the server's firewall. Please refer to https://my.hawkhost.com/knowledgebase/138/How-do-I-allow-remote-MySQL-connections.html regarding that.

You can either email [email protected] or use https://my.hawkhost.com/submitticket.php to create your ticket with this request. All we'd need you to provide is the remote IP(s) you're using to connect to MySQL and we'll get your hosting server's firewall updated accordingly. Thank you!

[Mark Lawrence]

1 hour ago, Brian said:

In addition to whitelisting the IP through cPanel as you've done, our support team will also need to whitelist the remote IP(s) you're using to connect through the server's firewall. Please refer to https://my.hawkhost.com/knowledgebase/138/How-do-I-allow-remote-MySQL-connections.html regarding that.

You can either email [email protected] or use https://my.hawkhost.com/submitticket.php to create your ticket with this request. All we'd need you to provide is the remote IP(s) you're using to connect to MySQL and we'll get your hosting server's firewall updated accordingly. Thank you!

Thank you Brian - I have submitted a Support ticket.