secure way to connect with remote Mysql database I created my application using MySQL and it relies completely on the database I have around 190 tables, and I'm afraid of security breaches and another problem is for remote access I have to add the IP addresses of the devices that would use it, and since they change dynamically I will need to regularly update the remote access IP addresses, what is a better option for the connection with the remote MySQL?  Currently I'm hosting it on my account at hostgator.

For now, the application is under a testing period so, I have time to change my approach with the database connection, It's a desktop application created using c# and visual studio 2013.

My question might seem silly but this is my first real life application so, I don't want to be a mess! 
Thanks
What are the clients?  PHP?  Java?  (etc, etc)  There are potentially serious hacks that can do things like "SQL Injection" through them.  That is perhaps more common than IP restrictions.

Do you have root only from some secure place?  Does it have a hardened password?

Are all the application 'users' granted access only to the desired database, and with only the desired permissions?  And are all the passwords hardened?

Where are the client passwords?  Visible in code?  That is, if a hacker can get to the code, are the passwords a useless defense?

SSL is only one issue.  If your provider does not allow for SSL, see if someone else does.  If not, then consider hosting the servers yourself; it's cheaper in the long run, but much more work.  And it would solve the IP problem.

Check skip_name_resolve.