error# 2002 can't connect to local mysql server '/var/mysql/mysql.sock' (2)

Hey Guys, you helped me once when I tryied to create a database : "Access denied for user ''@'localhost' ". On my Mac OS 10.4, I had no problem creating database and modifying it from the terminal. But I use Dreamweaver 8 to connect to MySQL, with its built-in feature "MySQL Connection" I write this:

Connection Name: con_test001
MySQL Server: localhost
User Name: root
Password: 55555
Database: test001 (which is a database I already createde using the terminal)

But when i click test i get this message:
MySQL Error# 2002
Can't connect to local mysql server '/var/mysql/mysql.sock' (2)

I Understand that some people have the same problem even when they aren't working with dreamweaver, only php and a text editor. I also tried to this:

cd /var
sudo mkdir mysql
cd mysql
sudo ln -s /private/tmp/mysql.sock mysql.sock

but It didn't work. i log on this way:
/usr/local/mysql/bin/mysql -u root –p

pbmods if you could help me with this again, i would appreciate it. Thank you

re: error# 2002 can't connect to local mysql server '/var/mysql/mysql.sock' (2)

Heya, markodilore.

Is MySQL running? Try running this in the Terminal:

If nothing comes up, then the database server is not running.

Try running this command:
The mysql.server file might not be in /usr/local/mysql/bin; it might be in /usr/local/mysql/support-files instead.

re: error# 2002 can't connect to local mysql server '/var/mysql/mysql.sock' (2)

Hey pbmobs, thanks for aswering me, again. I wrote that command and i got this message:

So I guess the server is running. Should i write the second part any way. because I keep getting that error message. thanks!

re: error# 2002 can't connect to local mysql server '/var/mysql/mysql.sock' (2)

Heya, markodilore.

Try restarting your MySQL server. Issue the following commands:
As always, mysql.server might be in /usr/local/mysql/support-files instead.

re: error# 2002 can't connect to local mysql server '/var/mysql/mysql.sock' (2)

Hey pbmods, thanks a lot. I wrote that code and it did turn mysql off and back on, I did it inmedietely following the other one:

But I still keep getting the error message, maybe i shouldn't have turned it back on right away, shoul I try to connect to mysql in a different way or is there something in this directory: '/var/mysql/mysql.sock' that need to be fixed. Please help me, thank you.

re: error# 2002 can't connect to local mysql server '/var/mysql/mysql.sock' (2)

I may be mistaken, but I believe that I fixed this by editing the /etc/my.cnf file. There are sections in there for both the mysql CLIENT and the mysql SERVER. At first I mistakenly just changed the first instance of "socket" and not the second one.

For me the fix was to change both occurrences of socket to

socket = /var/lib/mysql/mysql.sock

HTH,

wunderwood

re: error# 2002 can't connect to local mysql server '/var/mysql/mysql.sock' (2)

Yep that can also do it.
Another reason could be that MySQL is looking fo the sock file in /tmp instead. Moving the mysql.sock file from /var/lib/mysql/ to /tmp would do it.