Upgrading MySql to latest version in CentOS Web Panel [CWP]

I just want to mark that how to upgrading mysql in CWP, and below content are from here.

In this tutorial we will show you how to upgrade MySQL server in CentOS Web Panel.

1) Create full database backup (In case mysql server break we have backup to restore).

mysqldump --events --all-databases | gzip > /home/alldatabases.sql.gz

2) Install Remi repo.

cd /etc/yum.repos.d
wget http://rpms.famillecollet.com/enterprise/remi.repo


3) Now upgrade MySQL Server.

yum --enablerepo=remi update mysql-server
sudo mysql_upgrade


4) Restart MySQL Server.

service mysqld restart


If you want to do a fresh install of MySQL Server.

yum --enablerepo=remi install mysql-server


You are done with upgrading.

48,167 total views, 26 views today

Do you like this post?
  • Fascinated
  • Happy
  • Sad
  • Angry
  • Bored
  • Afraid


Leave a Reply