Right I have been trying to fix this all day and its really doing my head in now!!

I am trying to set up a connection to my database on my hosting, I am using Dreamweaver CS3 (Tried on Dreamweaver 8 aswell but still get same problem)

Here is the screen where I am entering the details:

http://www.corsasport.co.uk/carimage...connection.JPG

Then when I try to search for the database or if I manually enter the database and click test connection I get this error:

http://www.corsasport.co.uk/carimages/6191/error.JPG

Here is a screen shot of the PHPmyadmin page so you can see some of the details about it:

http://www.corsasport.co.uk/carimage...phpmyadmin.JPG

Where am I going wrong?!

I saw in another forum post a possible solution that talks about the OLD password system that dreamweaver use's (but I think they are talking about MX)

Got a full blown headache from this now as I just cant find a answer for it! Housemate is on the same hosting and his works fine. So I cant work out what the problem may be.

If anyone wants to help out in more detail I would be happy to provide my MSN address...

Thanks

Doug

Hi there,

Where is your database server located? You say you are trying to connect to your host, yet the screen shows localhost as the database server....

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.

Hi Imar,

Thanks for the reply. I am trying to connect to my host yes, the MySQL DB's are installed on the same system as the web server so it is in effect localhost.

But Dreamweaver isn't running on that machine is it?

You need to connect to the server from the DW box's point of view. With localhost, Dreamweaver looks on its own localhost.

Instead, you need to replace localhost with an IP address or something like database.yourprovider.com. You probably need to talk to your host to get these details.

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.