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


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 


Create  Remote Admin User

mysql -u root -p

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

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



To be continue …