MySQL Error#: 1045???

[jeramify]

i just bought hosting with hostmonster. i set up a new database & user in cpanel and whitelisted my ip. i then created a new connection for the database in navicat. i tested the navicat connection and it is working. i then define the site in dreamweaver and tested the connection. again, it said the connection was successful. finally, i attempted to create a mysql connection in dreamweaver. however, every time i click the "select" button beside, the database field, i get the error message:

MySQL Error#: 1045
Access denied for user (username_user)@hostxxx.hostmonster.com (using password: YES)

i have no clue what is going on here, but from what i have read this has something to do with a password issue.

i tried entering the shared server ip & my site name (site.com) in the mysql server field. both of those caused the error. i changed the mysql server to "localhost" and clicked "select" by the database and this time it let me choose my server. however, i question whether or not this is set up properly. can anyone tell me if this is correct?

[navsguardar]

I think this is correct because now you are already on the concerned server...

[jeramify]

thanks for the response. can anyone else confirm whether or not this is correct?

[shadmego]

When setting up a database connection in Dreamweaver, you will want to use the mysql server "localhost".

The reason, I believe, is because in Dreamweaver, you are already connected to the site, thus localhost would be the server. Making a remote connection directly to the database would require the domain name or IP address associated with that domain.

~regards