I have recently updated one of my servers from RH 9.0 to RH ES 3.0. However I can't start mysql because of it can't find /var/lib/mysql/mysql.sock

I can't find mysqladmin anyswhere. It should be in /usr/bin.

I tried to reinstall the latest verson from mysql.com as well. Nothing. When I install MySQL 4.0 rpm from mysql .com I still don't have mysqladmin. Anyone ehse run into this problem? What do I do?

anyone?

Please don't bump your posts until at least 24 hours please, as our Rules state.

Secondly, is it in your path? Have you tried to locate it with whereis or slocate, or even find?

And when you were trying to start mysql, did you actually create the default db's so it can actually start? That sock file it refers to is usually created after its started, etc and created the db's with mysql_install_db which creates that directory as well that its in.. etc.

More details please.

I found a way to fix it. for anyone else who runs into this problem this is what I did. I went to the mysql website and dowloaded the following RPM's

MySQL-client-4.0.18-0.i386.rpm
MySQL-devel-4.1.1-0.i386.rpm
MySQL-server-4.0.18-0.i386.rpm
MySQL-shared-4.1.1-0.i386.rpm
MySQL-shared-compat-4.1.1-0.i386.rpm

I installed the MySQL-shared-4.1.1-0.i386.rpm and MySQL-shared-compat-4.1.1-0.i386.rpm first (rpm -Uvh MySQL-shared-4.1.1-0.i386.rpm, rpm -Uvh MySQL-shared-compat-4.1.1-0.i386.rpm)

Then I installed the MySQL-server-4.0.18-0.i386.rpm (rpm -uvh MySQL-server-4.0.18-0.i386.rpm)

Then I installed the client and development packages the same way. After that everything was was kosher. Oh, I uninstalled the Redhat MySQL version before doing anything. Then installed the updated versions. You must install the shared and shared-compat first or you will get dependency errors. I hope someone else who has upgraded to RHES will find this useful. I have always just used the versions that came with Redhat. It's this type of stuff that makes me go more towards FreeBSD because of the inconsistencies with some Linux distros. granted I should probably install everything from source, it's nice to have the apps you need there. FreeBSD's port collection seems to be pretty straight forward and easy to use.

1 members found this post helpful.

Just install the MySQL client

I have come accross this same issue in RedHat Ent 3.0.

I've installed WebMin (and patched it) and the MySQL module gives this error:

The MySQL admin program /usr/bin/mysqladmin was not found on your system. Maybe MySQL is not installed, or your module configuration is incorrect.


I checked the /usr/bin directory and there is no mysqladmin at all. I checked the MySQL packages in Add/Remove Packages, and all have been installed.

I've seen this reported elsewhere on the web, but no one has an explanation yet.

Ideas or updates anyone?

Found out from RedHat that the mysqladmin is not included in the base install when selecting MySQL from the packages list.

The RPM needed is as follows:

mysql-server-3.23.58-1.9.i386.rpm

Install that, assuming you have already installed all MySQL packages from the RedHat install discs, and all should be gravy.

Well...I'd rather run the mysql version from mysql, besides the RHES editon of mysql is outdated.

Redhat and MySQL had some licensing disputes, or at least that's what a little bird told me. With that said, RHES doesn't carry the newset version which mysql recommends you should use. I't best to unistall the redhat version and use the mysql rpms from mysql.

I think it was MySql Client that finally gave me mysqladmin.
I'm really sick of having to dig into each and every product to figure out what someone REALLY meant. It's nice that the package install for the server tells you to run mysqladmin, but it doesn't tell you where to get that, and certainly anyone would be confused by the plethorific proliferation of versions/systems/packages/subsystems/servers/...

Thanks so much for sharing the helpful information -- it was still a problem 5 years later!