#!/bin/bash
tar xf mysql-8.0.17-linux-glibc2.12-x86_64.tar -C /alidata1/server
# 1
groupadd mysql
useradd -r -g mysql -s /bin/false mysql
# 2.
MYSQL_CNF_FILE=/etc/my.cnf
touch $MYSQL_CNF_FILE
echo "[client]" >> $MYSQL_CNF_FILE
echo "port=3306" >> $MYSQL_CNF_FILE
echo "socket=/tmp/mysql.sock" >> $MYSQL_CNF_FILE
echo "[mysqld]" >> $MYSQL_CNF_FILE
echo "port=3306" >> $MYSQL_CNF_FILE
echo "user=mysql" >> $MYSQL_CNF_FILE
echo "socket=/tmp/mysql.sock" >> $MYSQL_CNF_FILE
echo "basedir=/alidata1/server/mysql-8.0.17-linux-glibc2.12-x86_64" >> $MYSQL_CNF_FILE
echo "datadir=/alidata1/server/mysql-8.0.17-linux-glibc2.12-x86_64/data" >> $MYSQL_CNF_FILE
echo "log-error=/var/tmp/mysql.error.log" >> $MYSQL_CNF_FILE
# 2
cd /alidata1/server/mysql-8.0.17-linux-glibc2.12-x86_64
mkdir mysql-files
chown -R mysql:mysql mysql-files
chmod -R 750 mysql-files
bin/mysqld --initialize --user=mysql
bin/mysql_ssl_rsa_setup
cp support-files/mysql.server /etc/init.d/mysql.server
# 4.
/etc/init.d/mysql.server start
# 5
ETC_RC_LOCAL_FILE=/etc/rc.d/rc.local
MYSQL_HOME=/alidata1/server/mysql-8.0.17-linux-glibc2.12-x86_64
echo -e "#mysql - by haifeng" >> $ETC_RC_LOCAL_FILE
echo -e "MYSQL_HOME=${MYSQL_HOME}" >> $ETC_RC_LOCAL_FILE
echo -e 'export PATH=$PATH:$MYSQL_HOME/bin\n\n' >> $ETC_RC_LOCAL_FILE
source /etc/rc.d/rc.local