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!

Printed from: http://sysinfo.bascomp.org/2007/09/error-mysql-manager-or-server-pid-file-could-not-be-found/ .
© 2010.

10 Comments   »

  • MattX says:

    This worked for me

    sudo chown _mysql /var/mysql

  • playfish says:

    im normally wandering all across the web nearly all of the afternoon therefore I have the inclination to peruse an awful lot, which is not typically a beneficial factor as the majority of the blogs I find are made up of pointless crap copied from different internet websites a thousand times, nevertheless I have to give you credit this website is in reality not bad at all and even possesses a bit of authentic information, for that reason cheers for breaking up the phenomena of basically replicating other people's blogs and forums, in case you ever wanna have fun with playing a few hands of facebook poker together let me know - you have my e-mail :)

  • Hendrawan says:

    @playfish
    Thank you for your advice, I know this site is far from perfect, therefore if you could help to make it more perfect.

    BTW, sorry i don't play poker on facebook, i forgot i have facebook, thank for remind me :D

  • I look forward to reading what you happen to be considering next, because your weblog is a nice read, you're writing with enthusiasm.

  • Really good sharing this.

  • I was very pleased to find this site.I wanted to thank you for this great read!! I definitely enjoying every little bit of it and I have you bookmarked to check out new stuff you post.

  • A friend of mine suggested to me to check out your site. This is precisely the kind of information I was hunting for. I wish I have stumbled upon your blog sooner.

  • Hendrawan says:

    Filiberto, thanks to you, to still keep on eye to this poor blog, actually we always posting with shared spirit.
    I hope you can shared any experience in here to.

  • paramesh says:

    If there is no space in the particular directory, you may get this error. I faced the same problem and solved it.

    For me my /home directory was full. I deleted unwanted files and I got some free space. I started mysql service and worked fine

RSS feed for comments on this post

Leave a Reply