Install MySQL 5.7 under CentOS 7 for middle class children!

Ready to work

We use yum to install, easy and happy!
In order to download MySQL later, we can change the default yum source of CentOS and replace it with Ali's.

# Take a look at the default yum source
cd /etc/yum.repos.d/&& ll

# Back up the original yum source
mv /etc/yum.repos.d/CentOS-Base.repo /etc/yum.repos.d/CentOS-Base.repo.backup

# Download the new CentOS-Base.repo to/etc/yum.repos.d/
wget -O /etc/yum.repos.d/CentOS-Base.repo https://mirrors.aliyun.com/repo/Centos-7.repo

# refresh cache
yum clean all && yum makecache

Break first and then stand

In order to install MySQL smoothly and prevent various conflicts, let's uninstall the old MySQL related (mariadb is also mysql).

View the original MySQL and MariaDB of the system

yum list installed | grep mysql
yum list installed | grep maria

My centos7 shows as follows

mariadb-libs-5.5.40-1.el7_0.x86_64

If yes, perform uninstallation

yum -y remove mariadb-libs-5.5.35-3.el7.x86_64

start installation

Add rpm source to CentOS and choose newer source

wget dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

Install the downloaded rpm file

yum install mysql-community-release-el7-5.noarch.rpm -y

After the installation is successful, two files will be added under the /etc/yum.repos.d/ folder

Modify the mysql-community.repo file

In order to install 5.7, we modify the repo file

Use yum to install mysql

yum install mysql-community-server -y

Start the service, and set the boot to start

# A temporary password needs to be generated before startup, a certificate is required, and the certificate may expire and an update operation is required
yum update -y
# Start mysql service
service mysqld start
# Set mysql to boot up
chkconfig mysqld on

Get the temporary password of mysql

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

Login with temporary password

mysql -uroot -p
# enter password

Modify root password

set global validate_password_policy=0;set global validate_password_length=1;
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

Modify remote access permissions

grant all privileges on *.* to 'root'@'%' identified by '123456'with grant option;
flush privileges;

Set the character set to utf-8

vi /etc/my.cnf

# in[mysqld]Partially added:
character-set-server=utf8
# Add at the end of the document[client]Paragraph and in[client]Add paragraph:
default-character-set=utf8

The installation of Mysql 5.7 under CentOS 7 is successful, let's start playing!