Re: /tmp/mysql.sock disappeared on mac 10.3

[Michael Stassen]

Two possibilities:
1) mysqld could not create /tmp/mysql.sock because it is already there, 
which would mean mysqld is already running.  It appears you've ruled this out.

2) User mysql does not have permission to write to /tmp.  In Mac OS X, /tmp 
is a symlink to /private/tmp, so this really means mysql does not have 
permission to write to /private/tmp.  The fix:

  sudo chmod 1777 /private/tmp
Michael
Kenji LEFEVRE wrote:
Thanks you for your answer.
I have just tried what you said.
It doesn't work.
I type :
Raspoutine3:/usr/local/mysql/bin admin$ sudo ./mysqld_safe --user=mysql --log
Starting mysqld daemon with databases from /usr/local/mysql/data
041110 20:33:42  mysqld ended
Here are the line in the file 
'Raspoutine3:/usr/local/mysql/bin/data/Raspoutine3.local.err'
041110 20:33:41  mysqld started
041110 20:33:41  Warning: Setting lower_case_table_names=2 because file system 
for /usr/
local/mysql/data/ is case ins
ensitive
041110 20:33:42  Can't start server : Bind on unix socket: Permission denied
041110 20:33:42  Do you already have another mysqld server running on socket: 
/tmp/
mysql.sock ?
041110 20:33:42  Aborting
041110 20:33:42  /usr/local/mysql/bin/mysqld: Shutdown Complete
041110 20:33:42  mysqld ended
Though i can't find any mysqld running on my computer.
Can someone helps ?
Thanks, kenji.

Message du 10/11/04 14:06
De : "Michael Stassen" <[EMAIL PROTECTED]>
A : [EMAIL PROTECTED]
Copie &agrave; : [EMAIL PROTECTED]
Objet : Re: /tmp/mysql.sock disappeared on mac 10.3
The socket file is created by mysqld when it starts, and goes away when 
mysqld shuts down.  That is, you have no socket file because mysqld is not 
running, not the other way around.

You appear to be trying to start mysqld as OS user admin.  Normally, only 
root has the power make the switch to user mysql called for by --user=mysql. 
 Thus, mysqld starts running as user admin, who has no permission to touch 
data files owned by mysql.

Try `sudo bin/mysqld_safe --user=mysql --log`.  Better yet, do
  sudo -v
  sudo bin/mysqld_safe --user=mysql --log &
Michael
Kenji LEFEVRE wrote:

Hello,
OS : macos X 10.3
mysql version 4.0.21, for apple-darwin6.8 (powerpc)
it's seems that after my last crash,
the socket of mysql '/tmp/mysql.sock' has
been deleted
(and i have read afterwards that it should have
been protected with a sticky bit)
i thought that restarting mysql daemon would fix
this problem but i encounter the following problem :
when starting 
Raspoutine3:/usr/local/mysql admin$ bin/mysqld_safe --user=mysql --log

i get 
touch: /usr/local/mysql/data/Raspoutine3.local.err: Permission denied
chown: /usr/local/mysql/data/Raspoutine3.local.err: Permission denied
Starting mysqld daemon with databases from /usr/local/mysql/data
bin/mysqld_safe: line 302: /usr/local/mysql/data/Raspoutine3.local.err: Permission denied
rm: /usr/local/mysql/data/Raspoutine3.local.pid: Permission denied
bin/mysqld_safe: line 1: /usr/local/mysql/data/Raspoutine3.local.err: Permission denied
tee: /usr/local/mysql/data/Raspoutine3.local.err: Permission denied
041110 14:03:44  mysqld ended
tee: /usr/local/mysql/data/Raspoutine3.local.err: Permission denied

though user 'mysql' is the owner of directory '/usr/local/mysql/data/'
indeed
Raspoutine3:/usr/local/mysql admin$ ls -ld data/
drwxr-x---  13 mysql  wheel  442 10 Nov 00:34 data/
How can i fix this two problems :
recovering socket and starting daemon
thanks in advance, Kenji.



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]