MySQL 5 installation on Fedora Core 4

ERROR:
Starting MySQL Couldn't find MySQL manager or server[FAILED

SOLUTION:
Here is how I got 5.0.15 working under FC4…

Step 1.)
Rem out the line in /etc/my.conf that was setting basedir to /var/lib. As seen below:
user=mysql
#basedir=/var/lib

Step 2.)
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 3.)
Start the service..
# service mysql start