Install mysql 5.6 from yum source in centos7.4 system

System environment: centos7.4

1. Check whether the database is installed:

yum list installed | grep mysqld/mariadb

Second, install the yum source RPM resource package of the centos7 system with the mysql5.6 installation package:

rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

yum clean all

yum repolist

3. Install msyql5.6:

yum -y install mysql-community-server

Fourth, start the service:

systemctl start mysqld

systemctl enable mysqld

5. Reset password: It depends on the specific situation (can be omitted, log in without password)

#mysql_secure_installation

Set root password? [Y/n] y [Set root user password]

Remove anonymous users? [Y/n] y [Remove anonymous users]

Disallow root login remotely? [Y/n] n [Disallow root login remotely]

Remove test database and access to it? [Y/n] y [Delete test database]

Reload privilege tables now? [Y/n] y [Refresh privileges]

6. Check the mysql version:

mysql -V

mysql Ver 14.14 Distrib 5.6.39, for Linux (x86_64) using EditLine wrapper

7. Verification: (no password)

mysql -uroot -p 密碼

8. Set password and remote permissions

Database password setting: # set password for 'root'@'localhost'=password('userpasswd');

9. Configure the firewall

firewall-cmd --zone=public --add-port=3306/tcp --permanent