Downgraded from MYSQL 5, now mysql doesn't work

RampantLion

Registered
Jun 19, 2006
2
0
151
I followed the instructions here and downgraded MYSQL 5 back to mysql (4.0.27-standard)

I now get the error: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

When I attempt to start or reboot MYSQL, I also get this error: /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").

I have also rebuilt Apache and PHP after the downgrade.

Upgrading to MYSQL 5 is not an option as several websites on the machine had scripts that were incompatible with version 5. Can someone please help me find a fix for my MYSQL not working?
 

casey

Well-Known Member
Jan 17, 2003
2,288
0
191
Do a search for mysql and socket on these forums and follow the directions in the posts. There are several that deal with this. Also make sure that you don't have anything in my.cnf that would cause mysql not to start.