on the Database setup screen it will not accept my host string it keeps giving me this error:

Connection to Database failed
Unknown MySQL server host ' XXXXXXXX.db.52XXX44.hostedresource.com' (11004)
(X's replace my details obviously)

I have tried the ip for the database ive tried only entering local host.
I also called my host and they tested the database and said it tested fine so i am at a loss any help would be appreciated ty.