Engine
mysql-5.7.27-linux-glibc2.12-x86_64.tar.gz
Change OS limit
root#
vi /etc/security/limits.conf
mysql soft nproc 1024
mysql hard nproc 1024
mysql soft nofile 10240
mysql hard nofile 10240
User creation
root#
groupadd mysql
useradd -s /bin/bash -g mysql mysql
passwd mysql
Locate engine file
Deploy engine
gunzip mysql-5.7.27-linux-glibc2.12-x86_64.tar.gz
tar xvf mysql-5.7.27-linux-glibc2.12-x86_64.tar
ln -s mysql-5.7.27-linux-glibc2.12-x86_64 mysql
cd mysql
mkdir conf data scripts innodb logs
File setting
cd /home/mysql/mysql
vi startup.sh
#!/bin/bash
nohup bin/mysqld_safe --defaults-file=/home/mysql/mysql/conf/my.cnf &
vi shutdown.sh
#!/bin/bash
bin/mysqladmin -uroot shutdown
chmod +x startup.sh
chmod +x shutdown.sh
cd /home/mysql
vi mysql.sh
#!/bin/bash
mysql/bin/mysql -uroot
chmod +x mysql.sh
Configure the option file
Initialize MySQL database
Check a different way to use my.cnf properly ( Not working)
cd /home/mysql/mysql
bin/mysqld --initialize-insecure --basedir=/home/mysql/mysql --datadir=/home/mysql/mysql/data
nohup bin/mysqld_safe --defaults-file=/home/mysql/mysql/conf/my.cnf &