How to upgrade MySQL to version 5.6? How to upgrade MariaDB to version 10?
It is a purely administrative task. Contact your system administrator.
NOTE: Upgrade can be performed in command line by using the instructions below at your own risk:
For Ubuntu 12.04 and 14.04, Debian 7:
Ubuntu 14.04 is shipped with MySQL 5.5 by default.
/etc/mysql/my.cnf
:# cp /etc/mysql/my.cnf{,_original}
# wget http://dev.mysql.com/get/mysql-apt-config_0.6.0-1_all.deb
# 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.
# apt-get update
# apt-get install mysql-server
Agree when prompted to update /etc/mysql/my.cnf
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin psa
More information available in MySQL documentation at http://dev.mysql.com/
For CentOS 6:
# service mysqld stop
# mkdir /var/lib/mysqlcopy
# cp -aR /var/lib/mysql/* /var/lib/mysqlcopy
# vi /etc/yum.repos.d/atomic.repo
enabled = 0
# yum install http://dev.mysql.com/get/mysql57-community-release-el6-7.noarch.rpm
# vi /etc/yum.repos.d/mysql-community.repo
[mysql56-community]
enabled=1
[mysql57-community]
enabled=0
# yum install mysql
# service mysqld start
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin psa
For CentOS 7:
CentOS 7 basically shipped with MariaDB. MariaDB 10.x version is a drop in replacement for MySQL 5.5/5.6.
Please backup all existing databases using this KB article KB#213904125 and follow instructions on MariaDB site to update it:
https://mariadb.com/kb/en/mariadb/yum/
Then execute this command to update package version inside Plesk:
# plesk sbin packagemng -sdf
For Debian 8
Debian 8 basically shipped with MariaDB. MariaDB 10.x version is a drop in replacement for MySQL 5.5/5.6.
Please backup all existing databases using this KB article KB#213904125 and follow instructions on MariaDB site to update it:
https://mariadb.com/kb/en/mariadb/installing-mariadb-deb-files/
Then execute this command to update package version inside Plesk:
# plesk sbin packagemng -sdf