1. Create a backup of the original MySQL data

cp /var/lib/mysql /var/lib/mysql.original

2. Download the MySQL 5.7 RPM

wget http://repo.mysql.com/mysql57-community-release-el7.rpm -P /tmp/

3. Remove the MySQL-Community RPM that contains MySQL 5.6

yum remove mysql-community-release

4. Install the MySQL 5.7 RPM

rpm -ivh /tmp/mysql57-community-release-el7.rpm

5. Update the MySQL Repository to 5.7

yum update mysql

7. Let MySQL know that it received an upgrade

mysql_upgrade

Find Computer Parts Deals and Sales at buildmypcsales.com

3 thoughts on “Upgrade MySQL 5.6 to MySQL 5.7 – CentOS”

  1. Really helpful post. Thanks for sharing.
    Just wanted to point out here that one step is missing here, after step 5, we again need to move /var/lib/mysql.original to /var/lib/mysql to then mysql_upgrade will run successfully.

  2. Thank you , we are going to implement this in production. As Amol said, this data directory need to be moved.

  3. Error: Package: mysql-community-server-5.7.27-1.el7.x86_64 (mysql57-community)
    Requires: libsasl2.so.3()(64bit)
    Error: Package: mysql-community-client-5.7.27-1.el7.x86_64 (mysql57-community)
    Requires: libstdc++.so.6(GLIBCXX_3.4.15)(64bit)
    Error: Package: mysql-community-libs-5.7.27-1.el7.x86_64 (mysql57-community)
    Requires: libc.so.6(GLIBC_2.14)(64bit)
    Error: Package: mysql-community-client-5.7.27-1.el7.x86_64 (mysql57-community)
    Requires: libc.so.6(GLIBC_2.14)(64bit)
    Error: Package: mysql-community-server-5.7.27-1.el7.x86_64 (mysql57-community)
    Requires: systemd
    Error: Package: mysql-community-server-5.7.27-1.el7.x86_64 (mysql57-community)
    Requires: libc.so.6(GLIBC_2.17)(64bit)
    Error: Package: mysql-community-server-5.7.27-1.el7.x86_64 (mysql57-community)
    Requires: libstdc++.so.6(GLIBCXX_3.4.15)(64bit)

    ANY HELP ON THIS ?

Leave a Reply

Your email address will not be published. Required fields are marked *