Today I upgraded one of our servers MYSQL software from version 4 to version 5. Below is the steps of a successful install.
Go into your WHM > TweakSettings and select the MySQL 5 > Save it
login as root via SSH and run /scripts/mysqlup, it will do the upgrade for you.
Rem out the line in /etc/my.conf that was setting basedir to /var/lib. As seen below:
Create the directory “/var/run/mysqld” if it does not exist. Then chown that directory to mysql.mysql as below…
chown mysql.mysql /var/run/mysqld
Kindly check if a socket file exists on /tmp.
if not add one
root@server [~]# cd /tmp
root@server [/tmp]# ln -s /var/lib/mysql/mysql.sock .
Start the service..
service mysql start