Standard Operating Procedure (SOP)
For
MySQL Binary Installation
1. Introduction
In This Standard Operating Procedure (SOP), we get to know how to install MySQL in Linux. To provide
architecture view of application and step by step execution guidelines to team of a system in case of
disruption, to facilitate recovery within the stipulated timeframes to ensure business continuity with
minimal impact on business operation.
2.Application Architecture
Operating System Windows / Linux
Technology OpensourceDB
Database MySQL
Environment PROD/PRE-PROD/UAT/DR
3. Prerequisites
RHEL 7.6 is installed and up-to-date.
Administrative privileges are required to install MySQL.
Ensure that the system meets the minimum requirements for hardware, software, and storage.
Backup existing data, if applicable.
If there is any existing data that needs to be preserved, perform a backup before proceeding
with the installation.
4. Start Criteria
Bi-directional communication should be in place. Check telnet from primary server to secondary server
and vice versa.
Confidential Softcopy: 901712617.docx Page 1 of 7
5. Process Flow
To install MySQL Binary-generic on Linux Download the generic source code file (tar.gz) from MySQL
official website.
https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.33-linux-glibc2.28-x86_64.tar.gz
Under MySQL community server, select operating system as Linux-generic, and OS version as
preferred.
Then click on download.
Copy the link address and using wget command download it in Linux.
Extract the file on /usr/local/
Then add one group and user and checked
Then check the group add or not
Go to cd /usr/local
Create the symbolic link of MySQL
Create directories in /usr/local/ directory And change the permission of MySQL files
Check permissions
Then create configuration file
initialize the process
Create another one symbolic link
Start MySQL service
Check temporary password using cat command
Login into MySQL
After this, we need to reset the temporary password that we have got earlier.
6.Technical Flow
Firstly, Download the generic source code file (tar.gz) from MySQL official website.
https://dev.mysql.com/downloads/mysql/
Copy the link address and using wget command download it in linux.
Confidential Softcopy: 901712617.docx Page 2 of 7
Extract the file on /usr/local/ using below command .
After extract file then add one group and user and checked
Then check the group add or not using below command
Then go to below path
Cd /usr/local
Create the symbolic link of MySQL.
Confidential Softcopy: 901712617.docx Page 3 of 7
Create below directories in /usr/local/ directory And change the permission of MySQL files And create
one directory.
Check permissions
Then create configuration file
Confidential Softcopy: 901712617.docx Page 4 of 7
Save & exit
Cd MySQL
Go to the below path and initialize the process using below command , And copy file on below path.
Create another one symbolic link
Start MySQL service
Check temporary password using cat command
Login into MySQL
Confidential Softcopy: 901712617.docx Page 5 of 7
Reset root user password
5.6 Query to Be Used
Below queries needs to be performed for any activities:
wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.33-linux-glibc2.28-x86_64.tar.gz
[root@localhost ~]# tar -zxvf mysql-5.7.33-linux-glibc2.12-x86_64.tar.gz -C /
usr/local/
groupadd mysql
useradd -r -g mysql -s /bin/false mysql
getent passwd | grep mysql
cd /usr/local/
ln -s mysql-5.7.33-linux-glibc2.12-x86_64/ mysql
ls -lrth mysql
mkdir mysql-files
chown mysql:mysql mysql-files
chmod 750 mysql-files
mkdir mysql_log
chown -R mysql.mysql mysql_log/
vi /etc/my.cnf
[client]
[mysqld]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
log-error=/usr/local/mysql_log/mysql.err
cd /usr/local/mysql ./bin/mysqld --defaults-file=/etc/my.cnf --initialize --
user=mysql -- basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
cp ./support-files/mysql.server /etc/init.d/mysqld
ln -s /usr/local/mysql/bin/mysql /usr/bin
service mysqld start
cat /usr/local/mysql_log/mysql.err | grep password
Confidential Softcopy: 901712617.docx Page 6 of 7
Mysql –u root –p
mysql> alter user "root"@"localhost" identified by "Root@123";
Query OK, 0 rows affected (0.01 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
7.Known Error Logs
N.A
8. References
https://dev.mysql.com/downloads/mysql/
9.Made By
10.Escalation Matrix
Escalation Matrix
Manager Mr. Krishnanand Tiwari krishnanand.tiwari@cloverinfotech.com
Team Lead Mr.Sumit Kajwe sumitc.kajwe@cloverinfotech.com
Techno- MySQ Mon- Postgr-
logy L goDB eSQL DB2
Hyndav Amit.singh@cloverinfotech.com
Amit Mayur Subham Mayur.tawde@cloverinfotech.com
i
Subham.dash@cloverinfotech.com
Pran- Pranjal.sawant@cloverinfotech.com
Dhruv Vaibhav Dhruv.gujrati@cloverinfotech.com
jal
Vaibhav.margaje@cloverinfotech.com
Confidential Softcopy: 901712617.docx Page 7 of 7
