MySQL Connection

[RickHaden]

Hi all...

I have set up a Windows server running WAMP and use a Mac to develop websites using Dreamweaver CS3. I had a problem with passwords on the server, but have finally managed to be able to access the databases via PHPAdmin by removing the passwords. all is fine, but when I try to access the data via Dreamweaver, after changing the connections file to mirror the new information, I get the following error:

MySQL Error #1045

Access denied for user root@localhost ( using password=YES)

It should be using Password= NO...

WHat is happening?

Bestest

Rick

[David_Powers]

Thread moved to the Dreamweaver Application Development forum, which deals with PHP/MySQL and other server-side issues.

MySQL Error #1045

Access denied for user root@localhost ( using password=YES)

It should be using Password= NO...

You shouldn't be accessing MySQL with an unprotected root account, but if you want to, you need to edit the connection file created by Dreamweaver. The final line should look similar to this (the variable names will depend on what you called the connection):

$connQuery = mysql_pconnect($hostname_connQuery, $username_connQuery, $password_connQuery)
or trigger_error(mysql_error(),E_USER_ERROR); 

Remove the final argument to mysql_pconnect:

$connQuery = mysql_pconnect($hostname_connQuery, $username_connQuery)
or trigger_error(mysql_error(),E_USER_ERROR); 

[RickHaden]

Yeh, I know I shouldn't, but for the present, that is how the test server is set..

..not accessible from the outside world, so not too much of a problem...tried taking out the password

element of the script, but still have the same result...would this be cashed anywhere? I can't believe it is still returning a password=YES comment with no password being asked for?

Beat regards

Rick

[David_Powers]

Just done a quick test. You'll need to delete the variable that stores the password as well, or at least make it an empty string. It seems that Dreamweaver uses the variables in the background to make connections.

[RickHaden]

Thanks for that...I added another user to the database and connected via that and it all worked fine...

very strange...

Still all going now...thanks for your help...nice to know there are people around who know what they are doing and can be counted on in times of utter stress!

Best regards

Rick

[David_Powers]

Glad to hear you're back in business. I'll mark this thread as "assumed answered".

[RickHaden]

That's fine with me...