Upgrade MySQL using MySQL Community Repository

Find the correct release RPM for your version of CentOS from the MySQL Download Page (https://dev.mysql.com/downloads/repo/yum/)

cat /etc/redhat-release

  CentOS release 6.8 (Final)

wget https://dev.mysql.com/get/mysql57-community-release-el6-9.noarch.rpm

yum localinstall mysql57-community-release-el6-9.noarch.rpm

 

Edit the following file and enable the version of MySQL that you want to upgrade to. Also ensure you disable the ones you don\'t want.

 

vim /etc/yum.repos.d/mysql-community.repo

 

yum update mysql-server

 

mysql_upgrade

 If you\'re using Plesk, you will need to run mysql_upgrade with the following parameters:

mysql_upgrade -uadmin -p`cat /etc/psa/.psa.shadow`