Operating System: Redhat Linux
IP: 192.168.179.137
Create Local Yum Repository
Install RPM of MYSQL Database
cd /data/software/mysql
yum install mysql-commercial-common-8.4.4-1.* -y
yum install mysql-commercial-icu-data-files-* -y
yum install mysql-commercial-client-plugins-8.4.4-1.1.el8.x86_64.rpm -y
yum install mysql-commercial-libs-8.4.4-1.1.el8.x86_64.rpm -y
yum install mysql-commercial-client-8.4.4-1.1.el8.x86_64.rpm -y
yum install mysql-commercial-server-8.4.4-1.1.el8.x86_64.rpm -y
Create Directory for Database Files
mkdir /data/database
Change in MySQL Parameter File
vi /etc/my.cnf
#datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
datadir=/data/database
server-id = 1
log_bin = mysql-bin.log
Disable SELINUX
setenforce 0
vi /etc/selinux/config
SELINUX=disabled
Restart MYSQL Database Services
service mysqld restart
Collect One Time Temporary Password of Root User from mysql LOG (/var/log/mysqld.log)
Temporary Password =wc:sRdvnu3dU
Login MYSQL Database with Temporary Password and Changes this Password
mysql -u root -pzusr#5TfLydQ
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Oracle321#';
flush privileges;
Connect to MYSQL Database, Create Database and User for Testing / Verify
mysql -u root -pOracle321#
show databases;
create database test;
create user 'replica1'@'%' identified by 'Oracle321#';
grant replication slave on *.* to 'replica1'@'%';
FLUSH PRIVILEGES;
SHOW BINARY LOG STATUS;