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

[markodilore]

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

[pbmods]

Heya, markodilore.

Is MySQL running? Try running this in the Terminal:

ps -axc | grep mysqld
 

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

Try running this command:

sudo /usr/local/mysql/bin/mysql.server start
 

The mysql.server file might not be in /usr/local/mysql/bin; it might be in /usr/local/mysql/support-files instead.

[markodilore]

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

Marko-Dilore-Computer:~ markodilore$ ps -axc | grep mysqld
252  ??  S      0:00.55 mysqld

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

[pbmods]

Heya, markodilore.

Try restarting your MySQL server. Issue the following commands:

> /usr/local/mysql/bin/mysql.server stop
> /usr/local/mysql/bin/mysql.server start
 

As always, mysql.server might be in /usr/local/mysql/support-files instead.

[markodilore]

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:

Last login: Mon Oct 14 09:34:33 on console
Welcome to Darwin!
Marko-Dilore-Computer:~ markodilore$ sudo /usr/local/mysql/support-files/mysql.server stop
Shutting down MySQL.. SUCCESS! 
Marko-Dilore-Computer:~ markodilore$ sudo /usr/local/mysql/support-files/mysql.server start
Starting MySQL SUCCESS! 
Marko-Dilore-Computer:~ markodilore$

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.

[wunderwood]

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

[r035198x]

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

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.