Bind on unix socket: Permission denied?? HELP

[hisham]

I installed mysql-3.23.49, and when I tried to initialise and test my distribution: shell> /usr/local/mysql/bin/safe_mysqld --user=mysql &
That command fails immediately with mysqld daemon ended.
in the file `/usr/local/mysql/data/'hostname'.err I find:

- - - - - - - - - - - - - - - - - - - - -
mysqld started
Can't start server : Bind on unix socket: Permission denied
Do you already have another mysqld server running on socket: /usr/local/mysql/tmp/mysql.socket ?
Aborting

/usr/local/mysql/libexec/mysqld: Shutdown Complete

mysqld ended
- - - - - - - - - - - - - - - - - - - - -
Now, if another mysqld server running how can I remove mysql and reinstall it without get this conflict.

Any help PLS?
Thanks in advance.

 

[gheist]

You usually use lsof utility ( or netstat -an | less ) to determine if port you want to open is free and is not below 1024

 

[KarveR]

check the permissions on :
/usr/local/mysql/tmp/mysql.socket

/usr/local/mysql/tmp I think from memory should be 777 and mysql.sock should show as srwxrwxrwx, normally this error is shown if you dont have permission to access the /tmp dir in the path ***************************************
Party on, dudes!

 

[hisham]

Thank you for your answers.

I changed the prermissions of /tmp, now after:
shell> /usr/local/mysql/bin/safe_mysqld --user=mysql &

i get in the 'hostname'.err:
------------------------------
mysqld started
/usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
mysqld ended
------------------------------
How can i fix that?
Thanks in advance.

 

[KarveR]

Same thing, check the permissions on the directory and file
/mysql/host.frm

the mysql dir is most likely
.usr/local/mysql

to make sure you get the right one,
cd /
find . -name host.frm

and check the list of results. ***************************************
Party on, dudes!