Hey, I am a noob to running a dedicated server but I really need to reinstall MySQL 4.x back on my server. As default it had 4.x on it but I was stupid and upgraded it to 5 and now nothing works so I need to go back. Thanks in advance!
IMO MySQL5 is a better choice (4 is in EOL). Try to sort out the problems instead of downgrading. what's the exact problem?
Well the problem was MySQL could not find the mysql.sock file or something. From what I was reading, some files have been moved around since 4.x and I needed to upload all the MySQL 5 files. I had to get my host to downgrade for me for now sadly. Thanks though guys!
After you upgrade to MySQL5 you need to recompile PHP which would mean running the Apache build system again. It also I believes instructs you to run a command from ssh to complete the upgrade.
Yeah I did follow all the instructions using SSH and such and it said installation complete but it was showing as the MySQL server was down in WHM and when trying to run anything I would get the error saying it cannot connect due to missing mysql.sock. How am I supposed to upgade to MySQL5 if I am to not use WHM at all?
service mysql restart do that from ssh see what error it gives you. Then check the error log for mysql it may provide more detailed explanation as to why it's not working. You could also try running the mysql update script again from command line to get the latest versions. There is also the option of contacting cPanel support as WHM broke the MySQL (I am assuming thats what happened)