Scott- actually, I don't think this problem is on the remote server's side but inside DH. trungtamtuvan, did you ever solve this and if so how?
I am trying to get pages at DH to access a MySQL server hosted at ISP2. From my home web server/dev box the exact same pages as at DH can do this. The mysql user at ISP2 is wild-carded to allow access from any IP address. From within the DH world, however, I get the same error as trungtamtuvan:
Access denied for user 'username'@'curly.dreamhost.com' to database 'otherDBname'
the phrasing of the error message further makes me think this is a DH environment problem- I see no reason why the '@curly.dreamhost.com' should be entering that error message. If it said it could not connect to 'username'@'mysql.isp2.com' then I would agree it is ISP2, but this smells like a DH issue/policy.
has anyone successfully connected to an outside, remote mysql database from a page hosted in dreamhost?