How to install MySQL 5.7 in Centos 7 Server

This step should have been completed upon the installation of MySQL 5.7, but if you haven’t, you can complete it with:

System Updates

yum update

Install Repository

yum -y install yum localinstall https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm

Now you are ready to install MySQL 5.7 with:

yum -y install mysql-community-server

Firewall Configuration

firewall-cmd --add-service=mysql --permanent

firewall-cmd --reload

Enable MySQL Service 

systemctl enable mysqld

Start MySQL Service 

systemctl start mysqld

Get Temporary root Password:

 grep 'A temporary password' /var/log/mysqld.log |tail -1

MySQL Secure Installation 

/usr/bin/mysql_secure_installation

Create  Remote Admin User

mysql -u root -p

mysql> CREATE USER 'root'@'%' IDENTIFIED BY 'SecureP@ssw0rd';

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';

mysql> FLUSH PRIVILEGES;

To be continue …