Hi - I'm trying to set up my powerbook as esting server using instructions from a book. I've created a MySQL database and set it for all priviledges allowed to user mysql@localhost with password 'republic' using the following terminal command

<pre id=code><font face=courier size=2 id=code>GRANT ALL PRIVILEGES ON *.* TO mysql@localhost IDENTIFIED BY 'republic';</font id=code></pre id=code>

When I try and set up my MySql new connection in the databases panel in Dreamweaver MX 2004 I enter the following settings -

<ul>Connection Name - Comm
MySql server - localhost
User Name - mysql
Password - republic</ul>

When I then click the 'select' button for the database option I get the following Error Message

<pre id=code><font face=courier size=2 id=code>2002 Can't connect to local MySQL server though socket '/var/mysql/mysql.sock' (2)</font id=code></pre id=code>

Any ideas would be greatly appreciated as I don't really know what I'm doing wrong, or even what to try to fix...

Thanks