This is an issue that is really driving me nuts today:
Basically, I compiled MySQL from source (MySQL 5.1.14 on Ubuntu 9.04 on an ARM machine), and here is what happened when I tried to run it:
/etc/init.d/mysql start Starting MySQL.. * Manager of pid-file quit without updating file.
Digging into the error log, here is what I see:
110826 18:00:21 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var 110826 18:00:22 [ERROR] Can't start server : Bind on unix socket: Permission denied 110826 18:00:22 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 110826 18:00:22 [ERROR] Aborting 110826 18:00:22 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete 110826 18:00:22 mysqld_safe mysqld from pid file /usr/local/mysql/var/Serv.pid ended
So here is what I tried to do:
touch mysql.sock chown mysql:mysql mysql.sock chmod 1777 mysql.sock
And everything seems to be fine:
ls -la | grep mysql.sock -rwxrwxrwt 1 mysql mysql 0 2011-08-26 18:02 mysql.sock
But guess what, every time I tried to restart mySQL, the same error happened and it seems that for some reason, the sock file was gone.
I was running the whole process as root, so permission should not be a problem.
Any suggestion? Thanks!