How to install the mysql5.x principle from the MySQL official Yum repository as long as you get to the warehouse dependent on the installation of the warehouse depends on OK, I just use this installation of 5.7

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.

sudo wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm (Specific address right-click Get)

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

1. sudo yum localinstall mysql-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. [* * @localhost ~]# MySQL
2. mysql> set global read_only=0;
3. Query OK, 0 rows Affected (0.00 sec)
4. mysql> flush Privileges;
5. Query OK, 0 rows Affected (0.00 sec)
6. Mysql> quit
7. [* * @localhost ~]#/usr/bin/mysql_secure_installation

So you can re-update the root password!

2. [ERROR] Innodb:cannot create log files because data files are corrupt or the database is not shut down cleanly after C Reating the data files.

Workaround: Go to your MySQL data storage directory, delete the ibdata1 file, for example in my environment

1. #cd/var/lib/mysql
2. #mv ibdata1 Ibdata1.bak

3. [ERROR] Innodb:space header page consists of zero bytes in data file./ibdata1
Workaround: Modify the configuration file my.cnf

Adjust the values of the following parameters according to the size and requirements of the individual environment space

1. Innodb_buffer_pool_size = 256M
2. Innodb_log_file_size = 256M
3. Innodb_thread_concurrency = 16
4. Innodb_flush_log_at_trx_commit = 2

Add an article:

1. Innodb_flush_method=normal

4. ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:no)
Workaround: There are a lot of things on Google, and I just use/usr/bin/mysql_secure_installation to reset them once I'm in this situation.

Address: http://blog.csdn.net/horace20/article/details/26516689

How to install the mysql5.x principle from the MySQL official Yum repository as long as you get to the warehouse dependent on the installation of the warehouse depends on OK, I just use this installation of 5.7