can't do that...
as the database server protect the connection available only from inside connection only..
Nope - is IS possible for your Desktop client to communicate with your database at astahost.
1. Lets take an example database "abcd" - when you create a database/user on astahost, it's prefixed with your cPanel username, right ?
So supposing your cPanel username is "myself", your database name will be: myself_abcd
2. Now you need to create an user and grant him with all permissions to the database. Lets create an user called "admin". Even this will be prefixed with your cPanel username..
So your actual db access username will be: myself_admin
3. Grant this user with ALL permissions to that database
4. Now comes the critical part - specifying the ACCESS MASK to this database. Normally it always defaults to localhost. Under this circumstance, you can ONLY access this db using a script/client on your astahost account. You need to add a separate mask that will allow you to access the database from your own IP.
First, find out your own IP. If it is Static, nothing like it. But even if its Dynamic, no problem... Usually for dynamic IPs only the last two octets change everytime you log in... i.e.:
Say, your IP is: 100.200.300.400 - only the 300.400 keeps changing every time you login.. So we're going to replace this with the MySQL version of WildCard - % symbol
In the last option of cPanel MySQL Databases, you'll find a section named Access Hosts - here you've to enter the string,
100.200.%.% and click Add.
Now you can directly connect to this database straight from your desktop using your client... Supposing you're going to distribute this client to a lot of users who will upload data into your mysql db - make sure, instead of granting ALL permission, you set the permission to ONLY INSERT & SELECT - that will enable them to add new data and view old data - but not mess around with already added data.
For manipulating your database, adding/deleting/tables.. setting permissions etc.. general database administration job - I'd highly recommend this freeware tool named SQLYog which is freely downloadable at: http://www.webyog.com
Other than that you can also use MySQL's own Administrator and Query Browser.. all of them work just fine
Hope this helps - any more help with distributed apps and networked db's let me know..