• Web Hosting, VPS Hosting Company
  • +27 11 083 8382

Upgrading from MYSQL4 to MYSQL5 on a Cpanel Server

Upgrading from MYSQL4 to MYSQL5 on a Cpanel Server

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

Share
kazey

Leave a Reply

back to top
×