How to install MySQL5.6 from the official MySQL yum repository

In October 2013, the MySQL development team officially announced support for the Yum repository, which means we can now get the latest and best version of the MySQL installation package from this Yum library. This article installs MySQL5.6 on a newly installed CentOS6, and if you are unfamiliar with the new features of MySQL5.6, I recommend 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 and after importing the Yum Library, a simple yumupdate command will ensure that you are running on the latest release of MySQL5.6, including some updates on security features. Yum will also ensure that the relevant dependent libraries are imported, which will make our installation process simple. Go to http://dev.mysql.com/downloads/repo/and download Redhat Enterprise Linux 6/oracle Linux version 6.

Click on the link No Thanks, just start my download. Download it directly.

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

?

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

This Yum library contains Mysqlserver,mysql Workbench management tools and ODBC drivers, which can now be easily installed with the following command mysqlserver:

?

1	sudo yum install mysql-community-server

Now I can use Yum to simply manage MySQL updates and ensure that the latest releases are always available from 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.

Workaround:

?

1 2 3 4 5 6 7

[**@localhost ~]# mysql mysql> 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 re-update the root password!