Starting MySQLCouldn't find MySQL manager or server

[casey]

When upgrading to mysql5 many people who have customized their my.cnf files may find that mysql won't start. In this case, make sure that you comment out or remove the basedir config:

[mysql.server]
user=mysql
#basedir=/var/lib

Hope that saves somebody some time.

[LuisMello]

some problems

[richy]

Whhooo! We were getting the:
StartingMySQL Couldn't find MySQL manager or server [FAILED]
message after upgrading to MySQL 5 and this post fixed it! Many thanks!

[LuisMello]

My problem resolved, i remove my.cnf from mysql 4.x.

[hostace]

Thank you, that helped.

[avik]

yes. it's working now.

my /etc/my.cnf :

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/var/lib
old-passwords = 1

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


i have removed parameter (basedir=/var/lib) and mysql is working now.

[Arsalan]

Removing the basedir worked for us! Thanks.

[liquidcherry]

Hey casey,

Thx this should be a sticky:-)

Cheers,

Frank

[neonix]

Thanks casey

This saved me a lot of time :-)

[handsonhosting]

definitly needs to be made sticky!

[DWHS.net]

Removing the basedir worked for us! Thanks.

Hmm, worked for me too. Strange

[touma]

wow... thanks! Almost shooting myself! hahaha

[Finley Ave]

yeah, I was just getting a loop of rope to hang myself from the closet door, but the doorknob broke off, too many twinkies. Thanks Casey!!

[mambomouth]

Thank you for the tips guys it the basedir for me as well.
rhel 5 mysql 5.0.27 upgraded.

Cheers,
Brian

[kazey]

This is what worked for me.

Step 1.)
Go into your WHM > TweakSettings and select the MySQL 5 > Save it

Step 2.)
login as root via SSH and run /scripts/mysqlup, it will do the upgrade for you.

Step 3.)

Rem out the line in /etc/my.conf that was setting basedir to /var/lib. As seen below:

user=mysql
#basedir=/var/lib

Step 4.)

Create the directory "/var/run/mysqld" if it does not exist. Then chown that directory to mysql.mysql as below...

mkdir /var/run/mysqld
chown mysql.mysql /var/run/mysqld

Step 5.)
Kindly check if a socket file exists on /tmp.
if not add one
root@server [~]# cd /tmp
root@server [/tmp]# ln -s /var/lib/mysql/mysql.sock .

Step 6.)
Start the service..

service mysql start