Dreamweaver 8 and mysql connection

[netlatch]

I am using the Dreamweaver tutorial for dynamic website development for PHP and mysql on the mac. I am using my computer as the localhost. The site I have created so far can be tested using my computer as the testing server. PHP is working fine. I have mysql installed and running. I can access the DB from the terminal window and also by using a frontend application Navicat. I cannot however make the DB connection using Dreamweaver. I get this error "Mysql error#2002 Can't connect to local Mysql server through sockets '/var/mysql/mysql.sock'(2)" when I try to test the connection. DW8 creates the folders Tables and views but they are empty. Any ideas? Adobe says its the mysql but the frontend application made the connection fine. I have been working on this for a couple weeks. Any new ideas would be appreciated.

[SC68Cal]

I tried halfheartedly to make dreamweaver play nice with my database......

Then again, I hand code a lot of my programs because I don't think dreamweaver code is clean.

[Super Macho Man]

Does /var/mysql/mysql.sock exist?

[netlatch]

Does /var/mysql/mysql.sock exist?
where should it be? in the mysql directory?

[localoid]

See: can't connect (http://dev.mysql.com/doc/refman/4.1/en/can-not-connect-to-server.html)