No MySQL connection for DW CS3

Report · Nov 27, 2007

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.....

Report · Nov 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/

Report · Nov 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....

Report · Nov 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/

Report · Nov 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!

Report · Nov 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?

Report · Nov 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.

Report · Nov 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....

Report · Nov 29, 2007

andrea7422 wrote:
> 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")
> http://www.innovazio-net.com/images/db.png
> If I try to connect by DW, I can only select 2 others DB
> http://www.innovazio-net.com/images/conn.png
> This is very strange....

That is very odd indeed. I wonder what makes the test database show up,
but not the other ones? I wish I had experience with MySQL so I could
help you, but I don't, I can only guess, sorry.

Steve