shell脚本，一键部署mysql5.7
#!/bin/bash read -p "请先确认将光盘挂载到/mnt目录下，且mysql安装包mysql-boost-5.7.20.tar.gz在/opt目录下，y or n" START [ $START == "n" ] && exit 0 #关闭防火墙关闭核心防护 systemctl stop firewalld systemctl disable firewalld setenforce 0 echo 'SELINUX=disable SELINUXTYPE=targeted' > /etc/selinux/config yum -y install vim #超文本编辑器 yum -y install gcc gcc-c++ make pcre-devel expat-devel perl ncurses ncurses-devel bison cmake useradd -s /sbin/nologin mysql tar zvxf /opt/mysql-boost-5.7.20.tar.gz -C /opt cd /opt/mysql-5.7.20/ cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock -DSYSCONFDIR=/etc -DSYSTEMD_PID_DIR=/usr/local/mysql -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DMYSQL_DATADIR=/usr/local/mysql/data -DWITH_BOOST=boost -DWITH_SYSTEMD=1 make -j2 && make install chown -R mysql:mysql /usr/local/mysql/ echo '[client] port = 3306 default-character-set=utf8 socket = /usr/local/mysql/mysql.sock [mysql] port = 3306 default-character-set=utf8 socket = /usr/local/mysql/mysql.sock [mysqld] user = mysql basedir = /usr/local/mysql datadir = /usr/local/mysql/data port = 3306 character_set_server=utf8 pid-file = /usr/local/mysql/mysqld.pid socket = /usr/local/mysql/mysql.sock server-id = 1 #skip-grant-tables sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,PIPES_AS_CONCAT,ANSI_QUOTES ' > /etc/my.cnf chown mysql:mysql /etc/my.cnf echo 'PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH' >> /etc/profile echo 'export PATH' >> /etc/profile source /etc/profile cd /usr/local/mysql/ bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data cp usr/lib/systemd/system/mysqld.service /usr/lib/systemd/system/ systemctl enable mysqld systemctl start mysqld systemctl status mysqld netstat -anpt | grep 3306 [ $? -eq 0 ] && echo "数据库安装完成,请及时登录修改密码，初始密码为空密码"