Skip to main content
Participant
November 27, 2007
Question

No MySQL connection for DW CS3

  • November 27, 2007
  • 6 replies
  • 582 views
Hi, I have just installed my new copy of DW CS3 on Mac (Leopard 10.5) but I have a problem if I want to set a connection with MySQL database (ver. 5.0.45).
I set the following values in "MySQL connection parameters":

Connection name: test
Server MySQL: localhost
User: root
Password: root


Unfortunately the result is an error message:

MySQL Error#: 1045
Access denied for user 'root'@'localhost' (using password YES)


I'm sure the user 'root' works fine: if I use it with other applications (MySQL Administrator, MySQL Query Browser) everything is OK.
Please help me.....
This topic has been closed for replies.

6 replies

Inspiring
November 28, 2007
andrea7422 wrote:
> I have just made the following test:
> if I create a ne MySQL user without password (for example "andrea7422") and I
> try to make a connection with DW by:
>
> Connection name: test
> Server MySQL: localhost
> User: andrea74
> Password:
>
> I don't receive the errore message above, but I can select only two database:
> - information_schema
> - test
>
> Others DB inside are not shown.
> What it means?
>

it means you need to give the new user permission to see/use the other
tables.
Participant
November 28, 2007
Ok, I have set a new user (for example "andrea74" without password) and I have assigned all the privilages for a new DB (for example "mydb") img1
If I try to connect by DW, I can only select 2 others DB img2
This is very strange....
Participant
November 28, 2007
I have just made the following test:
if I create a ne MySQL user without password (for example "andrea7422") and I try to make a connection with DW by:

Connection name: test
Server MySQL: localhost
User: andrea74
Password:

I don't receive the errore message above, but I can select only two database:
- information_schema
- test

Others DB inside are not shown.
What it means?
Participant
November 28, 2007
Dear David, I'm warried becouse I can't use the DW funcionality for my projects.
I hope in the future you will find a solution to help me.
Bye!
Inspiring
November 27, 2007
andrea7422 wrote:
> Hi Powers, thank you for the replay.
> I spent all the day to find a solution on the web: I also tried the angry-fly suggestion without good results....

Sorry, I don't have an answer. I do plan testing everything on Leopard
eventually, but haven't had the time to get round to it yet.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/
Participant
November 27, 2007
Hi Powers, thank you for the replay.
I spent all the day to find a solution on the web: I also tried the angry-fly suggestion without good results....
Inspiring
November 27, 2007
andrea7422 wrote:
> Hi, I have just installed my new copy of DW CS3 on Mac (Leopard 10.5) but I
> have a problem if I want to set a connection with MySQL database (ver. 5.0.45).

I haven't set up MySQL on Leopard yet, but I know that it has been
causing a lot of problems. The following blog entry might help:

http://angry-fly.com/index.cfm/2007/10/26/Fix-for-MySQL-on-Leopard

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/