Can I connect remotely to a mysql database located on a web hosting server?
connection, delphi, mysql
Solution
Thank you very much everybody.
problem solved! :D
I contacted the support at the hosting company, and they told me its possible and gave me this useful link
http://kb.siteground.com/article/I_have_problems_accessing_my_mysql_database_remotely.html
all I had to do is to add a 'remote mysql host' which is my ip, and then I added the database to the windows odbc and it worked fine, as if it where local db (only slower).
Problem
I want to connect to a MySQL database that is running in a server located in a web hosting company (siteground). Can this be achieved?, is there a port to connect to the mysql database like (3306)? If not, are there any servers online where this can be achieved? PS: I'm using Delphi, and I'm using MySQL locally using ODBC.