mysql.socket fehlt!

[Maggi]

On my System (MacOSX) normally are the mysql.sock is located in the folder /private/tmp

Normally you can do something like this:

ln -s /private/tmp/mysql.sock mysql.sock

but my mysql.sock isn't there

I used sudo find /. -name "mysql.sock"

but my mysql.sock isn't on the Unixsystem.

I used

sudo touch /tmp/mysql.sock

but that wasn't good, only the failure message changed from:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)

to

ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (38)

I also deleted all mysql folders by using this side

http://www.entropy.ch/software/maco...-old-mysql.html

I installed it with the instructions of Marc Liyanage (Thx for this helpful side, this side is pretty good if you have mysql.sock, on all other Computers it worked fine!):

http://www.entropy.ch/software/maco...nstallprocedure

And finally reinstalled CompleteMySQL-4.0.15.dmg from

http://www.serverlogistics.com/mysql.php

and you will have a good explanation on a french site :-) :

http://www.augfrance.com/mediamomes...3?id_article=57

This booth sides for you it will be very easy to install MySQL on MacOSX (thx to the ServerLogistic Team and Bertrand Guigaz and Aaron Faby http://www.aaronfaby.com/ (take a look at this page :-))

So at the End my Problem isn't gone it is still there, i miss the mysql.sock file.

What can I do to get this file back into /private/tmp ?
(Maybe it will be helfull to now where the right place for musql.server is?
Because:

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

I ope there is some more help now, I specified my Problem.

Danke! Fuer all die, die mir geholfen haben mein Problem zu finden.

M.

[Maggi]

If you have the same Problem, all you have to know is:

That the mysql.sock is not really a file, it is a Unix domain socket. The program that uses it must create it. If the directory that mysqld wants to keep the file in exists, and has permissions that allow the user running mysqld
to write to the directory, the socket will be recreated.

The standard place for the socket is /tmp but that can be changed by compile options and /etc/my.cnf settings so you may have to look to find out where the socket belongs. I just scrolled down to the log file and it is /tmp that you need. (Thx! Dan for this hint)

Then you have to make something like this:

mysqladmin [-h ... -u ... -p...] shutdown
mysqld_safe --user=mysql &

that should restore your socket file... (Thx Miguel for this hint)

If you got now this failure by running mysqld_safe &:

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

Checkout that your Server (Maybe Samba, Apache etc...) is still running

Run the Server, run mysqld_safe & and you will succed!

best.

Markus

[fs111]

Wieso schreibst Du den Titel auf Deutsch und den Text in Englisch?

fs111