Today I decided to begin the upgrade process on my webserver by performing the upgrade of MySQL4.1 to MySQL5. Here are the steps:

• Login to WHM (Web Host Manager)
• Click on “Tweak Settings” and scroll down to MySQL®
• Check the Radio Button for 5.0, scroll down, and click Save
• Log in through SSH and perform the following commands:

SuperUser:

Navigate to your Scripts directory:

Upgrade MySQL:

Recompile MySQL Perl Modules:

Recompile Apache (use your previously saved configuration, unless you want to make some other changes):

Now at this point everything SHOULD be back to normal. There are two main issues you may run into however. The first is the one that I ran into. MySQL would fail to start with:

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)

To fix this I had to perform the following:

Rename the my.cnf file as it contains some old information:

Force MySQL to update again:

…and that should do the trick! However, another issue that you may run into is:

Starting MySQLCouldn’t find MySQL manager or server [FAILED]

To correct this run:

Find the line that states:

basedir=/var/lib

Comment it out by adding a pound sign in front of it:

Save the file and restart MySQL:

I’ll be adding this information to the Wiki as soon as it is ready. Enjoy!

(1 votes, average: 10 out of 10)

 Loading ...

Related Posts

• Webmaster’s Edge Tutorials On Tutorialized
• Wiki Updates: CPanel Information And MySQL Upgrade Issues
• The PHP5 Upgrade Is Now Complete
• Promoting The Edge Day Five: Submit, Submit, Submit!!
• Modsecparse.pl Causing Cronjob Errors To Be E-mailed To Me After MySQL5 Upgrade On CPanel