Today I upgraded one of our servers MYSQL software from version 4 to version 5. Below is the steps of a successful install.
Step 1.)
Go into your WHM > TweakSettings and select the MySQL 5 > Save it
Step 2.)
login as root via SSH and run /scripts/mysqlup, it will do the upgrade for you.
Step 3.)
Rem out the line in /etc/my.conf that was setting basedir to /var/lib. As seen below:
user=mysql
#basedir=/var/lib
Step 4.)
Create the directory “/var/run/mysqld” if it does not exist. Then chown that directory to mysql.mysql as below…
mkdir /var/run/mysqld
chown mysql.mysql /var/run/mysqld
Step 5.)
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 .
Step 6.)
Start the service..
service mysql start
Nairahost admin. :: Jan.27.2008 :: software :: No Comments »