MySQL Bugs: #18820: Couldn't find MySQL manager or server

Bug #18820	Couldn't find MySQL manager or server
Submitted:	5 Apr 2006 19:07	Modified:	3 Jul 2006 15:40
Reporter:	Vidhya Padmanabhan	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S2 (Serious)
Version:	5.0.19	OS:	Linux (Linux RedHat Enterprise Ver -4)
Assigned to:		CPU Architecture:	Any

Description:
Hi, 

I am trying to install mysql 5.0 on Linux RedHat Enterprise Ver -4. This OS comes along with mysql 4.0. I have uninstalled all the related files of verison 4.0 and I installed the following files from the mysql website -

MySQL-client-standard-5.0.19-0.rhel4.i386
MySQL-devel-standard-5.0.19-0.rhel4.i386
MySQL-shared-compat-5.0.19-0.rhel4.i386
MySQL-shared-standard-5.0.19-0.rhel4.i386
MySQL-standard-debuginfo-5.0.19-0.rhel4.i386
MySQL-test-standard-5.0.19-0.rhel4.i386
MySQL-server-standard-5.0.19-0.rhel4.i386

I installed them with --nodeps option. After the server standard file installation, the server is trying to start, but it fails giving this error -
Starting MySQLCouldn't find MySQL manager or server

I can't locate the mysql.sock file in the tmp or the /etc/init.d folders. 
If i say mysqld then I return back to the prompt with no error, but any other command like - mysqld_safe, or mysql_install_db (as i read from the bug reports - these commands create the mysql.sock) :
Can't connect to local mysql through socket /var/lib/mysql/mysql.sock
(neither can i see that file)

Please let me know as to what the problem is - do  I need to change the variables in my.cnf file.

How to repeat:
Occurs everytime after installation of the above files and when I try to start mysql

Thank you for a problem report. Please, send the results of the foillowing commands:

uname -a
rpm -q -a | grep -i mysql

Do you have SELinux enabled?

Hi, 
These are the results of the operation you had asked -

root@abc ~]# uname -a
Linux cepisprod.coe.uky.edu 2.6.9-5.ELsmp #1 SMP Wed Jan 5 19:30:39 EST 2005 i686 i686 i386 GNU/Linux

[root@abc ~]# rpm -q -a | grep -i mysql
MySQL-shared-compat-5.0.19-0.rhel4
libdbi-dbd-mysql-0.6.5-10.RHEL4.1
MySQL-client-standard-5.0.19-0.rhel4
MySQL-devel-standard-5.0.19-0.rhel4
MySQL-test-standard-5.0.19-0.rhel4
MySQL-standard-debuginfo-5.0.19-0.rhel4
MySQL-shared-standard-5.0.19-0.rhel4
MySQL-server-standard-5.0.19-0.rhel4

I had also tried the solution given in this link - But it hasn't helped.
http://forums.mysql.com/read.php?11,45754,54447#msg-54447

Someone found it work for RH version 4..
http://forums.mysql.com/read.php?11,45754,55837#msg-55837

Do I have to undo these changes in my.cnf?

And I do not have SELinux enabled...
(if i give selinuxenabled - I do not get any msg dispalyed)

This problem is holding back a lot of my work... It would be appreciated if someone could help asap...

Thanks
Vidhya

The version of my.cnf file in my system

Attachment: my.cnf.txt (text/plain), 423 bytes.

Please, try to repeat with a newer version, 5.0.21, and inform about the results.

I have found that when getting the error: "Starting MySQL ERROR! Couldn't find MySQL manager or server" you can go to the /etc/my.cnf file and comment out the basedir and everything will work again.

I am seeing this bug against mysql  Ver 14.12 Distrib 5.0.22, for pc-linux-gnu (i686) using readline 5.0 on RHEL 4.3

The workaround described above did not work for us.

basedir setting in my.cnf is just wrong for the package installed. That is why removing it solves the problem. See also bug #3233.

Solution for mysql Couldn't find the mysql server or manager

http://javasolution.blogspot.com/2007/04/mysql-couldnt-find-mysql-server-or.html

I have tried commenting the basedir in my.cnf on my Redhat AS and it worked for me.
The version I installed was 5.0.51a , earlier I aws using ver 4 which comes with redhat AS

In my case, I got this error:
Starting MySQL Couldn't find MySQL manager (/var/lib/bin/mysqlmanager) or server (/var/lib/bin/mysqld_safe)

I found there's no such directory /var/lib/bin, so I made one.Then I search for "mysqlmanager" and "mysqld_safe", and copy them to /var/lib/bin.
After all this, I started mysql service successfully.