fdnet

Member
May 5, 2004
23
0
151
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!!! :'(
 

fdnet

Member
May 5, 2004
23
0
151
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.
 

ZeusChicago

Active Member
Oct 9, 2005
44
0
156
The above two steps got me throught the 4.x to 5.x mySql upgrade.

Thank god for Search and the Forums!

Zeus