CentOS 6.5 Installation MySQL5.7 RPM

First, new features

MySQL 5.7 is an exciting milestone, adding new features such as SSL, JSON, and virtual columns, based on the default InnoDB engine. MySQL5.7 does a lot of "short" operations relative to PostgreSQL and mariadb.

Features:

Original: http://mysqlserverteam.com/whats-new-in-mysql-5-7-generally-available/

Translation: Http://www.oschina.net/translate/whats-new-in-mysql-5-7-generally-available

Second, upgrade operation

1. Uninstall the old version

1.1. View MySQL

rpm-qa| grep  -qa| grep mariadb

1.2. Uninstall MySQL

RPM-E--nodeps mysql-5.1. 7-e--nodeps mysql-connector-odbc-5.1. 5r1144-7-e-- Nodeps mysql-libs-5.1. 7-qa|  grep MySQL

1.3. Delete Data Directory

ls  -L  /var/lib|  grep MySQL
RM  -RF  /var/lib/mysql

The data catalog can be backed up for removal. The MYSQLD service checks the existence of the data directory when it initializes: if the data directory does not exist, MYSQLD creates it, and if the data directory exists and is not an empty directory (that is, contains a file or subdirectory), Mysqld displays an error message and aborts:
[ERROR]--initialize specified but the data directory exists. Aborting.

2, Installation MySQL5.7

2.1, Decompression MySQL5.7

tar -xvf mysql-5.7. 1. El6.x86_64.rpm-bundle. Tar

By the way, the installation environment is CentOS6.5, so should choose EL6 installation package, CentOS7 should choose EL7 installation package.

If the installation package corresponds to an incorrect system version, the installation will have a dependency error about glibc:

Warning:mysql-community-libs-5.7.14-1.el7.x86_64.rpm:header V3 dsa/sha1 Signature, key ID 5072e1f5:nokey
error:failed dependencies:
Libc.so.6 (glibc_2.14) (64bit) is needed by mysql-community-libs-5.7.14-1.el7.x86_64

2.2. Install RPM packages in accordance with the dependency relationship
Dependency relationships are Common→libs→client→server

RPM-IVH mysql-community-common-5.7. 1-ivh mysql-community-libs-5.7. 1-ivh mysql-community-client-5.7. 1-ivh mysql-community-server-5.7. 1. el6.x86_64.rpm

Do not want to lazy, the client also need to install ...

Third, initialize the MySQL5.7

3.1. Start Mysqld Service

Cd.. /sbinservice mysqld start

No manual initialization, longer start-up time, wait patiently

3.2. Check mysqld operation status

Service MYSQLD Status

Now you can tell that MySQL basic installation is successful.

3.3. Find the temporary login password

VI /var/log/mysqld.log

3.4. Login

Mysql-uroot-p

CentOS 6.5 Installation MySQL5.7 RPM