How to use WebHost MySQL

[Shafferassoc]

I may have this all wrong.
My Web host (iPowerWeb.com) provides a MySQL server. Using their PHPAdmin tool, I created a database, added a table, and populated the table.
My goal was to access that database from my home desktop using a MySQL connector like .netADO. Initially, though, I'm using MySQL administrator on my desktop, pointed to the

http://www site

with the proper username and password. I can ping the site, but can't see the database.

Again, maybe you can only use the database from applications that are resident on the web host (PHP?) but if it can be used as a backend to my desktop, I'd sure get more out of the money I pay to own the website (

http://WWW.ShafferAssoc.com)

Anybody got any ideas? Point me somewhere? Verify I'm full of kacka?

Thanx

 

[TonyGroves]

The web host could well have restrictions on which machines can access the MySQL server. That's for your own protection as much as anything else.

The best you might be able to do would be to set up MySQL on your own machine and transfer data to it periodically by downloading from the site into text files and importing those files into your own database.