Wrox Programmer Forums
|
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Dreamweaver (all versions) section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 29th, 2008, 06:00 PM
Registered User
 
Join Date: Mar 2008
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default MySQL Connection Problem!

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



 
Old March 30th, 2008, 09:00 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

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.
 
Old March 30th, 2008, 10:47 AM
Registered User
 
Join Date: Mar 2008
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.

 
Old March 30th, 2008, 11:15 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

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.





Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql & php connection problem. Manu Sharma PHP Databases 2 March 2nd, 2007 07:03 AM
PHP5 connection problem with MYSQL Calverstine PHP Databases 3 August 31st, 2005 01:27 AM
PHP5 connection problem with MYSQL Calverstine PHP How-To 0 August 22nd, 2005 05:09 AM
problem with JSP-MySQL connection pandjie Java Databases 2 November 18th, 2004 04:44 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.