Connect to MySql with DW CS3

[Hawkcode-vvUgXX]

I'm having a problem getting Dream Weaver to connect to my local MySQL. I can connect fine with Navicat, but not DW.


I have this error:
----
MqSql Error#: 2002

Can't connect to local MqSql sever through socket
'var/mysql/mqsql.sock' (2)
----


I've also gotten the error when trying to create a new connection:
-----
Http Error Code 404 FIle not found. Possible reasons for the problem.

1. There is no testing server running on the server machine. (It's my local machine and there is a MySql Server running, I connect with Navicat.)

2. The testing server specified for this site does not map to MMHTTPDB.php. Pluss the connection string.
------
I get this when trying to connect in the Setting up a MqSql connection when I press sellect database button.

Any ideas, this is driving me nuts.

My machine is a MAC.

Thanks

Rich

[Newsgroup_User]

Hawkcode wrote:
> Can't connect to local MqSql sever through socket
> 'var/mysql/mqsql.sock' (2)

I've just been helping someone else with the same problem. You need to
create a symbolic link to /tmp/mysql.sock. I'm not a Mac expert, so
wasn't able to give detailed instructions, but the other person kindly
posted them here once he/she had worked out what to do. Here they are again:

In Terminal I found there was
a /tmp/mysql.sock but nothing at /var/mysql/ Not even a directory for
mysql. So
I had to create one and then make the -s link. I also had to use super user
permissions to do it.

On a Mac 10.4.10, here's what you do--In Terminal
cd /var/
sudo mkdir mysql
cd (to get back to root)
sudo ln -s /tmp/mysql.sock /var/mysql/mysql.sock

At any time you can run the ls command to see all the files and
directories within the current directory, so you can keep track of where
you are. Always hit cd (enter) to go back to home (root).

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

[mdonahue]

quote:

---

Originally posted by: David Powers
In Terminal I found there was
a /tmp/mysql.sock but nothing at /var/mysql/ Not even a directory for
mysql. So
I had to create one and then make the -s link. I also had to use super user
permissions to do it.

On a Mac 10.4.10, here's what you do--In Terminal
cd /var/
sudo mkdir mysql
cd (to get back to root)
sudo ln -s /tmp/mysql.sock /var/mysql/mysql.sock

At any time you can run the ls command to see all the files and
directories within the current directory, so you can keep track of where
you are. Always hit cd (enter) to go back to home (root).

---

I was getting the same Error #2002 on my Mac, OSX 10.5.1, MySQL 5.0.51a, PHP 5.2.4. Followed this procedure and DWCS3 connects just fine.

Thanks David.

Mike D.

[Hawkcode-vvUgXX]

Did that, however I have no mysql.sock file anywhere on my computer.

So what goes in that file?

[Newsgroup_User]

Hawkcode wrote:
> Did that, however I have no mysql.sock file anywhere on my computer.
>
> So what goes in that file?

If you're connecting to Navicat, you must have a mysql.sock file. It's
what MySQL uses to connect to client programs. It's automatically
created by MySQL when the server starts up. It should either be in
/var/mysql or /tmp. You won't be able to see it in Finder. You need to
look for it in Terminal.

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

[Hawkcode-vvUgXX]

It is in tmp, however 0 bites.

I also have Zend Sudio installed if that means anything.

Thanks, you the only brave soul to try and help and I have done postings all over.

Rich

[Newsgroup_User]

Hawkcode wrote:
> It is in tmp, however 0 bites.

That doesn't matter: mysql.sock is simply a reference to the MySQL server.

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

[Hawkcode-vvUgXX]

well I still have the same proble... :(

Rich