remote MySQL connection denied

[biturica]

Hello, I cannot connect to my MySQL database remotely. This is the error I get: 1045 - access denied for dbuser@adsl.blahblah.bellsouth.blah (Using password: yes) I tried setting up a new connection Navicat Lite 8 (Windows version). I have created a new MySQL database and user in Cpanel. I have added that user to the database with all privileges. I have white listed the IP for this computer in my account profile. In Navicate, I take the default port of 3306, I use mydomain.tld as the host, and I have tried the user name both with and without the bluehost account name and underscore preceding the actual db user name. If I try to use 4406 as the port, I get a different error (cannot connect to MySQL server). At least using 3306 I seem to get almost there, but it's not recognizing the db credentials I just set up. I know this has been asked before, and I've read many threads on this topic via Google and tried everything advised in those threads and pages. Nothing seems to work. Anyone who can help me, your assistance would be greatly appreciated.

[felgall]

You need the account name and underscore on the front of both the database name and user name.

[biturica]

Hi, thanks for your reply Navicat only prompts me for username, password, and host and on the username, i've included the account name and underscore this is on the windows machine at work; trying it at home with mysql query browser, and that program just hangs and i have to do a force quit

[felgall]

There is probably a config file that contains the wrong values since it needs to know how to access the database. The values you enter into the application to log into the application are probably different from those that need to be in the config file to connect to and login to the database.

[biturica]

Hey, I wanted to thank you guys for your help. What ended up being the problem was I failed to have a wildcard as the last octet of my white-listed IP address.