The software library that comes with centos can only install mysql5.1, and subsequent versions will not work. You can only find a way to upgrade mysql.

1: Check whether the system comes with MySQL installed

yum list installed | grep mysql

2: Delete the mysql that comes with the system and its dependent commands:

yum -y remove mysql-libs.x86_64

3: Add rpm source to CentOS, and select the newer source command:

wget -i http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm

yum -y install mysql57-community-release-el7-7.noarch.rpm

yum repolist enabled | grep mysql

4: Install mysql server command:

yum install mysql-community-server

5: Start the mysql command:

service mysqld start

6: Check whether mysql is self-starting, and set to enable the self-starting command:

chkconfig --list | grep mysqld

chkconfig mysqld on

7: set password:

mysqladmin -uroot -pxxxxxx

Other operations are the same as other versions.

Record the pits encountered, friends who need to install, remember to pay attention:

1、 The first time I installed it under centos 7, it went smoothly. Later, several tests failed in centos 6. You need to update glibc to 2.17. Updating glibc is a big pit, everyone can do what they can.

2、 Starting from MySQL 5.6.8, the MySQL RPM installation package uses a more secure installation method. Instead of the previous password being empty, mysql will randomly assign a password to the root account, but this password can’t do anything and can only log in. Some people say The password is in /root/.mysql_secret, but I did not find it, I found it in the log file. as follows:

grep "A temporary password"/var/log/mysqld.log

Centos yum install mysql5.6 or above