DW pbp connection problem

Report · Jul 19, 2006

I have two php/mysql sites up and running on my local computer. I'm in the middle of setting up another one, but keep getting the following error when trying to establish a MySQL connection using Dreamweaver:

MySQL error #: 1045
Access denied for user . . . (using password: YES)

My username and password have not changed. I checked to make sure the settings I'm using for the new site match the old sites. I then checked the old sites and sure enough, they're no longer working.

Yet phpadmin and mysql are running. I used phpmyadmin to set up the d/b which I cannot connect to.

I've just searched Macfixit and don't see anything about 10.4.7 breaking either mysql or php.

Any ideas what's going on?

mac 10.4.7
phpMyAdmin 2.6.4-pl3
DW 8.0.1

Report · Jul 19, 2006

doonavitch wrote:
> I have two php/mysql sites up and running on my local computer. I'm in the
> middle of setting up another one, but keep getting the following error when
> trying to establish a MySQL connection using Dreamweaver:
>
> MySQL error #: 1045
> Access denied for user . . . (using password: YES)

You don't say which versions of PHP and MySQL you are using, but MySQL
4.1 and higher requires PHP 5 and mysqli. Otherwise you need to use the
OLD_PASSWORD() protocol in MySQL:

http://dev.mysql.com/doc/refman/5.0/en/old-client.html

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/