How to install MySQL5.6 from the official MySQL Yum Repository

On July 6, October 2013, the MySQL development team officially announced the support for the Yum repository, which means that we can now get the latest and optimum version of the MySQL installation package from this Yum library. This article will install MySQL5.6 on a newly installed CentOS6. If you are not familiar with the new features of MySQL5.6, I suggest starting with the new features of MySQL 5.6, which have many very useful features.

First, we need to download the Yum repository file from the MySQL developer website. After importing the Yum repository, a simple yumupdate command will ensure that you are running on the latest release version of MySQL5.6, includes updates to some security features. Yum also ensures that the relevant dependent libraries are imported, which will simplify the installation process. Go to http://dev.mysql.com/downloads/repo/and download Redhat Enterprise Linux 6/Oracle Linux 6.

Click linkNo thanks, just start my download.Download directly.

After the download is complete, import the Yum library to your local device:

sudo yum localinstallmysql-community-release-el6-*.noarch.rpm

This Yum library contains MySQLServer, MySQL workbench management tool, and ODBC driver. Now you can install MySQLServer simply using the following command:

sudo yum install mysql-community-server

Now, I can use Yum to easily manage MySQL updates and always get the latest version from the software library on the official website.

Appendix:

1. root password update failed

ERROR 1290 (HY000): The MySQL server is running with the -- skip-grant-tables option so it cannot execute this statement.

Solution:

[**@localhost ~]# mysqlmysql> set global read_only=0;Query OK, 0 rows affected (0.00 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)mysql> quit[**@localhost ~]# /usr/bin/mysql_secure_installation

So you can update the root password again!