Cannot connect to mysql database in dreamweaver

[djpassion]

I am having problems trying to access my live bluehosts mysql database through dreamweaver, whenever I try to make a new database connection and click the 'test' button I get the following error:

Mysql Error#: 1045

Access Denied for user '####@127.0.0.1' (using password: YES)

I have a testing server on my PC which is apache, I have also got Mysql server installed to test locally, however when I try to connect to the bluehosts mysql server which seems to also use apaches 'localhost' host name, this seems to conflict with the server I have installed locally.

I have whitelisted my IP in the customer profile to allow to conect remotely although this doesnt help.

[aceofspades]

same thing happened to me. Actually i cant use dreamweaver at all. It conncts but it doesnt allow to upload anything.

[areidmtm]

Localhost ONLY work is you are working locally. You are NOT working locally with bluehost. You have to remotely connect to bluehost.

To do that, you either 1) enable you account for SSH and create an SSH tunnel to connect with the MySQL in which you'd use localhost (which dreamweaver cannot do) OR 2) add you IP in the MySQL manager and also email you IP to bluehost so they can add it to the firewall so you can remotely connect.

your mysql server name would be your domain

But when you use the MySQL part in dreamweaver, it doesnt allow you to add any new entries or view anything. The only thing you really can do it see the tables. That's all.

I also use dreamwaver and I have it set up to use FTP and it uploads fine.

[shafaki]

I have a dynamic IP that changes every time I go online. I do not have a static IP. I have SSH enabled in my bluehost account. I am using Dreamweaver and wish to connect to MySQL on my bluehost account through Dreamweaver.

I've tried to add my IP through the cPanel, but it didn't work. Do I have to email support to allow my IP through their firewall each time my dynamic IP changes?

[felgall]

You need a static IP address if you want to set up remote connection to your online database.

[shafaki]

Oh too bad. I used to be able to do DB from dreamweaver with my previous host. But at least this restrictions is because bluehost has better security. But it unfortunately makes things more complicated.