ERROR! MySQL manager or server PID file could not be found!
Don’t Panic if you get this error when you start, restart or stop your mysql engine.
I get error like this "/etc/init.d/mysql: /usr/local/bin/hostname: not found
/etc/init.d/mysql: /usr/local/bin/hostname: not found
ERROR! MySQL manager or server PID file could not be found!"
when i restart the mysql, yes..dont panic,
solved:
# ps -ef |grep mysql|awk '{print $2}'|xargs kill -9
# vi /tmp/mysql.sock
# chown -R mysql:mysql mysql.sock
# which mysql
/usr/local/mysql/bin/mysql
# find / -name hostname
/usr/bin/hostname
/usr/ucb/hostname
# ln -s /usr/bin/hostname /usr/local/bin/hostname
# vi /etc/init.d/mysql
find
basedir=
datadir=
change with
basedir=/usr/local/mysql
datadir=/usr/local/mysql/var
# /etc/init.d/mysql start
Starting MySQL
SUCCESS!
Try following solution
http://javasolution.blogspot.com/2007/04/mysql-couldnt-find-mysql-server-or.html
Arun
4 Dec 07 at 2:52 am
This worked for me
sudo chown _mysql /var/mysql
MattX
30 Aug 09 at 7:09 am