Database error anyone help?

[sc2142]

Im trying to connect my vb.NET Application to my database witch is on my website. Im getting this error: 

"An unhandled exception of type 'MySql.Data.MySqlClient.MySqlException' occurred in MySql.Data.dll 

Additional information: Unable to connect to any of the specified MySQL hosts." 

The error is being called on "sconnection.open()" 

Ive searched google and i cant find whats wrong. My site is through Hosting24. Code: http://pastebin.com/Gd4JCakQ

[Bobadilla]

(01-24-2017, 03:54 PM)sc214e 2 Wrote: Im trying to connect my vb.NET Application to my database witch is. Im getting this error:

Hi sc2141, I just got the same error. Did you find a fix?

[brandonio21]

Hello sc2142 and Bobadilla! Welcome to BP forums and thanks for posting.

Assuming that the MySQL host is properly setup with Hosting24 and that your connection string is correct, I think the most probable cause of this error is a lack of permission. Usually, MySQL databases only allow access to the database from the same machine that the database is running on.

That is to say, I believe this error is happening because your database does not allow connection from remote hosts.

What kind of control panel does Hosting24 give you? There should be a setting somewhere about MySQL remote connections, where you should whitelist access from either:
1. Your machine's IP address
2. All IP Addresses (0.0.0.0)

Hope this helps and keep us updated on your progress!