#!/bin/bashDatadir=/data
yum install -y libaio
tar -xzvf ./rpms/mysql/mysql-5.7.29-linux-glibc2.12-x86_64.tar.gz -C /tmp
if [ ! -d "$Datadir" ] then    mkdir -p  /datafi
mv /tmp/mysql-5.7.29-linux-glibc2.12-x86_64 /data/mysql
#在/data/mysql目录中创建data,log,backup三个目录,分别对应数据目录,日志目录,备份目录mkdir -p /data/mysql/datamkdir -p /data/mysql/logmkdir -p /data/mysql/backup
#创建系统mysql组和mysql用户groupadd mysqluseradd -r -g mysql mysql
#目录授权chown -R mysql:mysql /data/mysql
mv /etc/my.cnf /etc/my.cnf.bak
#修改mysql配置文件my.cnfcat >>/etc/my.cnf<<EOF[mysqld]basedir=/data/mysqldatadir=/data/mysql/datasocket=/data/mysql/mysql.socklog-error=/data/mysql/log/mysqld.logport=3306server-id=1max_connections=1000innodb_buffer_pool_size = 1024Mlower_case_table_names = 1max_connect_errors=9999character-set-server = utf8mb4collation-server = utf8mb4_unicode_cilog-bin=/data/mysql/log/mysql-bin.logbinlog_cache_size=4Mexpire_logs_days=7max_binlog_size=100Mbinlog_format=MIXEDsql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO
[client]default-character-set = utf8mb4socket=/data/mysql/mysql.sock
[mysql]default-character-set = utf8mb4EOF
#数据库初始化/data/mysql/bin/mysqld --user=mysql --datadir=/data/mysql/data --basedir=/data/mysql --initialize
cp -rf /data/mysql/support-files/mysql.server /etc/init.d/mysqldchkconfig --add mysqldchkconfig  mysqld on/etc/init.d/mysqld startln -s /data/mysql/bin/mysql /usr/bin/
Pass=$(grep 'A temporary password' /data/mysql/log/mysqld.log |awk  '{print $NF}')mysql_passwd=$(openssl rand -hex 6)
/data/mysql/bin/mysqladmin -uroot -p"$Pass" password $mysql_passwd
# print mysql passwordecho -e "[\033[33mNOTICE\033[0m] Your mysql passwd is \033[33m${mysql_passwd}\033[0m" >> /root/passwd.txt

chmod +x install_mysql.sh./install_mysql.sh