How To - Upgrade MySQL 5.5 to 5.6

How to upgrade MySQL to version 5.6? Upgrade can be performed by using the instructions below at your own risk:

For Ubuntu 12.0.8 and 14.04, Debian 7:

Ubuntu 14.04 is shipped with MySQL 5.5 by default. Create a full server backup and server snapshot.

Create a backup of /etc/mysql/my.cnf:

# cp /etc/mysql/my.cnf{,_original}

Add the MySQL APT Repository: Go to the download page for the MySQL APT repository at http://dev.mysql.com/downloads/repo/apt/.

Select and download the release package for your platform:

    # wget http://dev.mysql.com/get/mysql-apt-config_0.6.0-1_all.deb

Install the downloaded release package:

    # dpkg -i mysql-apt-config_0.6.0-1_all.deb

During the installation of the package, you will be asked to choose the versions of the MySQL server and other components that you want to install. If you are not sure which version to choose, do not change the default options selected for you. You can also choose none if you do not want a particular component to be installed. After making the choices for all components, choose Apply to finish the configuration and installation of the release package.

Update package information from the MySQL APT repository:

    # apt-get update

Upgrade MySQL:

    # apt-get install mysql-server

Agree when prompted to update /etc/mysql/my.cnf In Plesk go to Tools & Settings > Server Components and click Refresh

More information available in MySQL documentation at http://dev.mysql.com/

For CentOS 6:

Stop MySQL service:

# service mysqld stop

Back up MySQL databases:

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

Disable Atomic repository, if it is enabled:

# vi atomic.repo
  enabled = 0

Install MySQL-community repository:

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

Disable upgrade to MySQL 5.7, enable upgrade to MySQL 5.6:

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

Install MySQL packages:

# yum install mysql

Start MySQL service:

# service mysqld start

Upgrade MySQL databases:

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