MySQL not starting

Hi,

There is prob a post somewhere on this forum somewhere but i cannot find it!

I just upgraded mysql from 4.1 to 5.0 (Brave step!) and now i cannot get the server to boot mysql up. I've tried all sorts but most of what I have found is for if MySQL is running...

Starting MySQL Couldn't find MySQL manager or server [FAILED]
...
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
Unable to reset root MySQL password. at /scripts/securemysql line 150.
Install Complete

(I added the Install Complete at the end for entertainment value!)

Just to give you a run down of what i have tried in desperations already:

cd /var/lib/mysql
touch mysql.sock
chown mysql:mysql mysql.sock
chmod 1777 mysql.sock
ln -s /var/lib/mysql/mysql.sock /tmp
chmod 1777 /tmp
/scripts/mysqlup --force (extract above of what it is saying)
/etc/rc.d/init.d/mysql restart

Code:

MySQL manager or server PID file could not be found!       [FAILED]
Starting MySQLCouldn't find MySQL manager or server        [FAILED]

Im crying now so please help!!! :'(

 

I'm now crying with joy :D

i was playing around and did:

su mysql
/usr/sbin/mysqld

*****

and that seemed to do the trick.