Editing Radico-Sitapur-Master-Slave Replication (section)

==Installation of MySQL community server on both the server==

 VPN details
 Login URL : https://125.21.90.50:6443/userportal/webpages/myaccount/login.jsp#51349
 User : tetra
 Pass : Tetra@2211

 Server DetailsS
 TNT Server1 : 172.18.40.211 (Master Server)
 TNT Server2 : 172.18.40.212 (Slave Server)
 Username:root
 Pass:R@D!C)@a

 Mysql login Details
 username:root
 Pass:Pass@12345 

'''Note: Run this commands as a Root User'''
 vi /etc/yum.repos.d/mysql80-community.repo
 [mysql80-community]
 name=MySQL 8.0 Community Server
 baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/6/$basearch/
 enabled=1
 gpgcheck=0
 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
       file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
 yum repolist all
 yum install mysql-community-server
 setenforce 0
 vi /etc/sysconfig/selinux                (disabled selinux)
 systemctl enable mysqld.service
 systemctl start mysqld.service
 grep 'temporary password' /var/log/mysqld.log
 mysql_secure_installation (set the password for root mysql)
 mysql -pPass@1234
 CREATE USER 'root'@'%' IDENTIFIED BY 'Pass@1234'; 
 GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
 ##Run this command only on master server
 create user 'repl_user'@'%' identified by 'Pass@1234';
 Grant replication slave on *.* to 'repl_user'@'%';
 ALTER USER 'repl_user'@'%' IDENTIFIED WITH mysql_native_password BY 'Pass@1234';
 ##To check the permission of the user run the below command
  show grants for replica;   

**************************************************************************************************