How to upgrade MySQL 5.5 to 5.6 or 5.7 in Vesta CP

CentOS 6 guide look so.

Stop MySQL:

# service mysqld stop

Make backup copy of bases MySQL:

# mkdir /var/lib/mysqlcopy
# cp -aR /var/lib/mysql/* /var/lib/mysqlcopy

Disable Atomic repo, if enabled

# vi atomic.repo
  enabled = 0

Add MySQL-community repo:

# yum install http://dev.mysql.com/get/mysql57-community-release-el6-7.noarch.rpm

Disable update to 5.7, enable 5.6 version:

# nano /etc/yum.repos.d/mysql-community.repo
  [mysql56-community]
  enabled=1
  [mysql57-community]
  enabled=0

Install MySQL:

# yum install mysql

Start MySQL service:

# service mysqld start

Update databases:

# mysql_upgrade -uroot

ItHelp