mysql administrator connection problem

[reasonbomb]

Hi, I'm trying to set up MySQL Administrator to work with bluehost, but I keep getting an access denied error.
I have remote access enabled for the db I want, I have my ip whitelisted with bluehost, I have port 3306 forwarded for the machine I'm working on, and I've tried using the following for login data:

host: numerical ip for my account, boxMYBOXNUMBER.bluehost.com , mydomain.com

username: mydomain_adminuser, adminuser

where adminuser is the account I made to administer the db I'm trying to connect to.
I should note that my domain name is 10 chars long, and all the account prefixes are listed with the last two chars cut off. So, mydomain-2_adminuser etc. I've been using the 8 char version since that's how bluehost has it listed.

What am I doing wrong?
Any help would be greatly appreciated.

[TheWebHostingHero]

Try using a "%" for remote access instead of specifying your IP. This will grant access to any IP / domain to your database.

Of course this isn't a good idea, you should remove it once you've checked if it works. If it doesn't work, it's not a remote access issue.

[reasonbomb]

Thanks!! Adding % to access hosts worked, but you're spot on about it being a security issue. What's the proper format for adding a db to the host list? Adding my8chardomain_databasename does not work. Neither does %databasename%.