You should tell us what is the error message you get.
I think that it could be permission denied or something like that. In this case you should tell your database administrateur to add an user that is allowed to connect to the server from yourr remote machine
I am using mysql center, an application that allows you to connect to MySQL databases. The error i get is
[PoolDatabase] ERROR 2003: Can't connect to MySQL server on 'www.trurodistrictpool.org.uk' (10061)
The password and username given to me by the domain hosting company is correct.
I have even logged into the database via the web, (its running phpmyadmin on the web), i can see the database and can add tables,
but what i want to do is connect to my remote database/tables upload the new tables and display them on the web.
I can't beleive its causing me so many problems. I can't get much help from the hosting company they just send me to mysql.com, but as i am new to this i need the help. Even if i could just connect Access to the remote database and upload that way thats all i want to do. I run a pool league so supto date league tables and results is essential.