[plug] MySQL installation via RPM gone wrong ... ?

[Richard Mortimer]

Greetings folks,

I've been asked to install MySQL on our Linux server which originally seemed
like a fairly easy task.

I had a copy in .tar.gz format from a while ago, so I read through the doco
and it basically said that I'm better off to get the RPM if I'm running
RedHat (which I am) so I grabbed a copy of the server and client version
from their site, http://www.mysql.com/downloads/mysql-3.23.html - dragged
this to the /tmp directory and did an:

rpm -i MySQL-server(rest of name).rpm MySQL-client(rest of name).rpm

as per the documentation found on the MySQL site here:

http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Linux-RPM

This seemed to work, however upon closer inspection, parts of the
installation appeared to be wrongly located, according to the documentation
found in the link below, I should have a scripts directory and (the most
disturbing) I'm missing the mysqladmin program.

http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Post-installation

Attempts to stop and start the server are thwarted - the mysqld_safe (and
safe_mysqld) don't appear to exist, and querying the server through
/usr/sbin/mysqld gives the result:

[root at webserver local]# /usr/sbin/mysqld
030801 11:50:07  Can't start server: Bind on TCP/IP port: Address already in
use
030801 11:50:07  Do you already have another mysqld server running on port:
3306 ?
030801 11:50:07  Aborting

030801 11:50:07  /usr/sbin/mysqld: Shutdown Complete

[root at webserver local]#

Although I am not aware of having another mysqld running.

I'm at a total loss at the moment; does anyone have any ideas how I can fix
this installation???

Thanks

Richard