爱威尔-mysql5.7.X_Linux - Generic（tar.gz）+centos 7.X 自动化安装脚本

参考：<a href="http://suifu.blog.51cto.com/9167728/1855415" target="_blank">http://suifu.blog.51cto.com/9167728/1855415</a> 
 
 ###### 二进制自动安装数据库脚本root密码MANAGER将脚本和安装包放在/root目录即可############### ######数据库目录/usr/local/mysql############ ######数据目录/data/mysql############ ######慢日志目录/data/slowlog############ ######端口号默认3306其余参数按需自行修改############ ################## #author：rrhelei@126.com# ################## #!/bin/bash # Check if user is root if [ $(id -u) != "0" ]; then echo "Error: You must be root to run this script, please use root to install" exit 1 fi clear echo "=========================================================================" echo "A tool to auto-compile & install MySQL 5.7.15 on Redhat/CentOS Linux " echo "=========================================================================" cur_dir=$(pwd) #set mysql root password echo "===========================" mysqlrootpwd="MANAGER" echo -e "Please input the root password of mysql:" read -p "(Default password: MANAGER):" mysqlrootpwd if [ "$mysqlrootpwd" = "" ]; then mysqlrootpwd="MANAGER" fi echo "===========================" echo "MySQL root password:$mysqlrootpwd" echo "===========================" #which MySQL Version do you want to install? echo "===========================" isinstallmysql57="n" echo "Install MySQL 5.7.15,Please input y" read -p "(Please input y , n):" isinstallmysql57 case "$isinstallmysql57" in y|Y|Yes|YES|yes|yES|yEs|YeS|yeS) echo "You will install MySQL 5.7.15" isinstallmysql57="y" ;; *) echo "INPUT error,You will exit install MySQL 5.7.15" isinstallmysql57="n" exit esac get_char() { SAVEDSTTY=`stty -g` stty -echo stty cbreak #dd if=/dev/tty bs=1 count=1 2> /dev/null stty -raw stty echo stty $SAVEDSTTY } echo "" echo "Press any key to start...or Press Ctrl+c to cancel" char=`get_char` # Initialize  the installation related content. function InitInstall() { cat /etc/issue uname -a MemTotal=`free -m | grep Mem | awk '{print  $2}'` echo -e "\n Memory is: ${MemTotal} MB " #Set timezone #rm -rf /etc/localtime #ln -s /usr/share/zoneinfo/Asia/Shanghai /etc/localtime #Delete Old Mysql program rpm -qa|grep mysql rpm -e mysql #Disable SeLinux if [ -s /etc/selinux/config ]; then sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config fi setenforce 0 } #Installation of depend on and optimization options. function InstallDependsAndOpt() { cd $cur_dir cat >>/etc/security/limits.conf<<eof>
 * soft nproc 65535
 * hard nproc 65535
 * soft nofile 65535
 * hard nofile 65535
 EOF
 
 echo "fs.file-max=65535" >> /etc/sysctl.conf
 }
 
 #Install MySQL
 function InstallMySQL57()
 {
 echo "============================Install MySQL 5.7.15=================================="
 cd $cur_dir
 
 #Backup old my.cnf
 #rm -f /etc/my.cnf
 if [ -s /etc/my.cnf ]; then
 mv /etc/my.cnf /etc/my.cnf.`date +%Y%m%d%H%M%S`.bak
 fi
 
 echo "============================MySQL 5.7.15 installing…………========================="
 #mysql directory configuration
 tar xvf /root/mysql-5.7.15-linux-glibc2.5-x86_64.tar.gz
 
 rm -rf /usr/local/mysql/*
 
 mv /root/mysql-5.7.15-linux-glibc2.5-x86_64/* /usr/local/mysql/
 groupadd mysql -g 512
 useradd -u 512 -g mysql -s /sbin/nologin -d /home/mysql mysql
 
 rm -rf /data/
 mkdir -p /data/mysql
 mkdir -p /data/slowlog
 chown -R mysql:mysql /data/mysql
 chown -R mysql:mysql /usr/local/mysql
 chown -R mysql:mysql /data/slowlog
 
 
 #edit /etc/my.cnf
 
 SERVERID=`ifconfig eno16777736 | grep "inet " | awk '{ print $2}'| awk -F. '{ print $3$4}'`
 cat >>/etc/my.cnf<
 <eof>
 [client]
 port=3306
 socket=/tmp/mysql.sock
 default-character-set=utf8
 
 [mysql]
 no-auto-rehash
 default-character-set=utf8
 
 [mysqld]
 port=3306
 character-set-server=utf8
 socket=/tmp/mysql.sock
 basedir=/usr/local/mysql
 datadir=/data/mysql
 explicit_defaults_for_timestamp=true
 lower_case_table_names=1
 back_log=103
 max_connections=3000
 max_connect_errors=100000
 table_open_cache=512
 external-locking=FALSE
 max_allowed_packet=32M
 sort_buffer_size=2M
 join_buffer_size=2M
 thread_cache_size=51
 query_cache_size=32M
 #query_cache_limit=4M
 transaction_isolation=REPEATABLE-READ
 tmp_table_size=96M
 max_heap_table_size=96M
 
 ###***slowqueryparameters
 long_query_time=1
 slow_query_log = 1
 slow_query_log_file=/data/slowlog/slow.log
 
 ###***binlogparameters
 log-bin=mysql-bin
 binlog_cache_size=4M
 max_binlog_cache_size=8M
 max_binlog_size=1024M
 binlog_format=MIXED
 expire_logs_days=7
 
 ###***relay-logparameters
 #relay-log=/data/3307/relay-bin
 #relay-log-info-file=/data/3307/relay-log.info
 #master-info-repository=table
 #relay-log-info-repository=table
 #relay-log-recovery=1
 
 #***MyISAMparameters
 key_buffer_size=16M
 read_buffer_size=1M
 read_rnd_buffer_size=16M
 bulk_insert_buffer_size=1M
 
 #skip-name-resolve
 
 ###***master-slavereplicationparameters
 server-id=$SERVERID
 #slave-skip-errors=all
 
 #***Innodbstorageengineparameters
 innodb_buffer_pool_size=512M
 innodb_data_file_path=ibdata1:10M:autoextend
 #innodb_file_io_threads=8
 innodb_thread_concurrency=16
 innodb_flush_log_at_trx_commit=1
 innodb_log_buffer_size=16M
 innodb_log_file_size=512M
 innodb_log_files_in_group=2
 innodb_max_dirty_pages_pct=75
 innodb_buffer_pool_dump_pct=50
 innodb_lock_wait_timeout=50
 innodb_file_per_table=on
 
 [mysqldump]
 quick
 max_allowed_packet=32M
 
 [myisamchk]
 key_buffer=16M
 sort_buffer_size=16M
 read_buffer=8M
 write_buffer=8M
 
 [mysqld_safe]
 open-files-limit=8192
 log-error=/data/mysql/error.log
 pid-file=/data/mysql/mysqld.pid
 
 EOF
 
 
 
 
 /usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --user=mysql --datadir=/data/mysql --basedir=/usr/local/mysql --initialize-insecure
 
 cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
 chmod 700 /etc/init.d/mysqld
 chkconfig --add mysqld
 chkconfig --level 2345 mysqld on
 
 cat >> /etc/ld.so.conf.d/mysql-x86_64.conf<
 <eof>
 /usr/local/mysql/lib
 EOF
 ldconfig
 
 if [ -d "/proc/vz" ];then
 ulimit -s unlimited
 fi
 
 /etc/init.d/mysqld start
 
 
 cat >> /etc/profile <
 <eof>
 export PATH=$PATH:/usr/local/mysql/bin
 export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/mysql/lib
 EOF
 
 /usr/local/mysql/bin/mysqladmin -u root password $mysqlrootpwd
 
 cat > /tmp/mysql_sec_script<
 <eof>
 use mysql;
 delete from mysql.user where user!='root' or host!='localhost';
 
 grant all privileges on *.* to 'root'@'%' identified by 'MANAGER';
 flush privileges;
 EOF
 
 /usr/local/mysql/bin/mysql -u root -p$mysqlrootpwd -h localhost < /tmp/mysql_sec_script
 
 #rm -f /tmp/mysql_sec_script
 
 
 #/etc/init.d/mysqld restart
 
 
 
 
 echo "============================MySQL 5.7.15 install completed========================="
 }
 
 
 
 function CheckInstall()
 {
 echo "===================================== Check install ==================================="
 clear
 ismysql=""
 echo "Checking..."
 
 if [ -s /usr/local/mysql/bin/mysql ] && [ -s /usr/local/mysql/bin/mysqld_safe ] && [ -s /etc/my.cnf ]; then
 echo "MySQL: OK"
 ismysql="ok"
 else
 echo "Error: /usr/local/mysql not found!!!MySQL install failed."
 fi
 
 if [ "$ismysql" = "ok" ]; then
 echo "Install MySQL 5.7.15 completed! enjoy it."
 echo "========================================================================="
 netstat -ntl
 else
 echo "Sorry,Failed to install MySQL!"
 echo "You can tail /root/mysql-install.log from your server."
 fi
 }
 
 #The installation log
 InitInstall 2>&1 | tee /root/mysql-install.log
 InstallDependsAndOpt 2>&1 | tee -a /root/mysql-install.log
 InstallMySQL57 > /dev/null
 CheckInstall 2>&1 | tee -a /root/mysql-install.log
 </eof>
 
 </eof>
 
 </eof>
 
 </eof>
 
 </eof> 
 改动了一些 主要是 我用的是centos7.2  所以有些改动是针对版本的。 
 
 
<pre class="prettyprint lang-js">###### 二进制自动安装数据库脚本root密码MANAGER将脚本和安装包放在/root目录即可###############
######数据库目录/usr/local/mysql############
######数据目录/data/mysql############
######慢日志目录/data/slowlog############
######端口号默认3306其余参数按需自行修改############

##################
#author：rrhelei@126.com#
##################
#!/bin/bash

# Check if user is root
if [ $(id -u) != "0" ]; then
    echo "Error: You must be root to run this script, please use root to install"
    exit 1
fi

clear
echo "========================================================================="
echo "A tool to auto-compile & install MySQL 5.7.15 on Redhat/CentOS Linux "
echo "========================================================================="
cur_dir=$(pwd)

#set mysql root password
    echo "==========================="

mysqlrootpwd="MANAGER"
    echo -e "Please input the root password of mysql:"
    read -p "(Default password: MANAGER):" mysqlrootpwd
    if [ "$mysqlrootpwd" = "" ]; then
        mysqlrootpwd="MANAGER"
    fi
    echo "==========================="
    echo "MySQL root password:$mysqlrootpwd"
    echo "==========================="

#which MySQL Version do you want to install?
echo "==========================="

isinstallmysql57="n"
    echo "Install MySQL 5.7.15,Please input y"
    read -p "(Please input y , n):" isinstallmysql57

case "$isinstallmysql57" in
    y|Y|Yes|YES|yes|yES|yEs|YeS|yeS)
    echo "You will install MySQL 5.7.15"

isinstallmysql57="y"
    ;;
    *)
    echo "INPUT error,You will exit install MySQL 5.7.15"

isinstallmysql57="n"
    exit
    esac

get_char()
    {
    SAVEDSTTY=`stty -g`
    stty -echo
    stty cbreak
    #dd if=/dev/tty bs=1 count=1 2> /dev/null
    stty -raw
    stty echo
    stty $SAVEDSTTY
    }
    echo ""
    echo "Press any key to start...or Press Ctrl+c to cancel"
    char=`get_char`

# Initialize  the installation related content.
function InitInstall()
{
    cat /etc/issue
    uname -a
    MemTotal=`free -m | grep Mem | awk '{print  $2}'`  
    echo -e "\n Memory is: ${MemTotal} MB "
    #Set timezone
    #rm -rf /etc/localtime
    #ln -s /usr/share/zoneinfo/Asia/Shanghai /etc/localtime

#Delete Old Mysql program
    rpm -qa|grep mysql
    rpm -e mysql

#Disable SeLinux
    if [ -s /etc/selinux/config ]; then
    sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config
    fi
    setenforce 0

}

#Installation of depend on and optimization options.
function InstallDependsAndOpt()
{
cd $cur_dir

cat >>/etc/security/limits.conf<<eof *="" soft="" nproc="" 65535="" hard="" nofile="" eof="" echo="" "fs.file-max="65535"">
 > /etc/sysctl.conf
}

#Install MySQL
function InstallMySQL57()
{
echo "============================Install MySQL 5.7.15=================================="
cd $cur_dir

#Backup old my.cnf
#rm -f /etc/my.cnf
if [ -s /etc/my.cnf ]; then
    mv /etc/my.cnf /etc/my.cnf.`date +%Y%m%d%H%M%S`.bak
fi

echo "============================MySQL 5.7.15 installing…………========================="
#mysql directory configuration
tar xvf /root/mysql-5.7.15-linux-glibc2.5-x86_64.tar.gz
rm -rf /usr/local/mysql/*
mv /root/mysql-5.7.15-linux-glibc2.5-x86_64/* /usr/local/mysql/
groupadd mysql -g 512
useradd -u 512 -g mysql -s /sbin/nologin -d /home/mysql mysql
rm -rf /data/
mkdir -p /data/mysql
mkdir -p /data/slowlog
chown -R mysql:mysql /data/mysql
chown -R mysql:mysql /usr/local/mysql
chown -R mysql:mysql /data/slowlog

#edit /etc/my.cnf
SERVERID=`ifconfig eno16777736 | grep "inet " | awk '{ print $2}'| awk -F. '{ print $3$4}'`
cat >>/etc/my.cnf<
 <eof [client]="" port="3306" socket="/tmp/mysql.sock" default-character-set="utf8" [mysql]="" no-auto-rehash="" [mysqld]="" character-set-server="utf8" basedir="/usr/local/mysql" datadir="/data/mysql" explicit_defaults_for_timestamp="true" lower_case_table_names="1" back_log="103" max_connections="3000" max_connect_errors="100000" table_open_cache="512" external-locking="FALSE" max_allowed_packet="32M" sort_buffer_size="2M" join_buffer_size="2M" thread_cache_size="51" query_cache_size="32M" #query_cache_limit="4M" transaction_isolation="REPEATABLE-READ" tmp_table_size="96M" max_heap_table_size="96M" ###***slowqueryparameters="" long_query_time="1" slow_query_log="1" slow_query_log_file="/data/slowlog/slow.log" ###***binlogparameters="" log-bin="mysql-bin" binlog_cache_size="4M" max_binlog_cache_size="8M" max_binlog_size="1024M" binlog_format="MIXED" expire_logs_days="7" ###***relay-logparameters="" #relay-log="/data/3307/relay-bin" #relay-log-info-file="/data/3307/relay-log.info" #master-info-repository="table" #relay-log-info-repository="table" #relay-log-recovery="1" #***myisamparameters="" key_buffer_size="16M" read_buffer_size="1M" read_rnd_buffer_size="16M" bulk_insert_buffer_size="1M" #skip-name-resolve="" ###***master-slavereplicationparameters="" server-id="$SERVERID" #slave-skip-errors="all" #***innodbstorageengineparameters="" innodb_buffer_pool_size="512M" innodb_data_file_path="ibdata1:10M:autoextend" #innodb_file_io_threads="8" innodb_thread_concurrency="16" innodb_flush_log_at_trx_commit="1" innodb_log_buffer_size="16M" innodb_log_file_size="512M" innodb_log_files_in_group="2" innodb_max_dirty_pages_pct="75" innodb_buffer_pool_dump_pct="50" innodb_lock_wait_timeout="50" innodb_file_per_table="on" [mysqldump]="" quick="" [myisamchk]="" key_buffer="16M" read_buffer="8M" write_buffer="8M" [mysqld_safe]="" open-files-limit="8192" log-error="/data/mysql/error.log" pid-file="/data/mysql/mysqld.pid" eof="" usr="" local="" mysql="" bin="" mysqld="" --defaults-file="/etc/my.cnf" --user="mysql" --datadir="/data/mysql" --basedir="/usr/local/mysql" --initialize-insecure="" cp="" support-files="" mysql.server="" etc="" init.d="" chmod="" 700="" chkconfig="" --add="" --level="" 2345="" on="" cat="">
 > /etc/ld.so.conf.d/mysql-x86_64.conf<
 <eof usr="" local="" mysql="" lib="" eof="" ldconfig="" if="" [="" -d="" "="" proc="" vz"="" ];then="" ulimit="" -s="" unlimited="" fi="" etc="" init.d="" mysqld="" start="" cat="">
 > /etc/profile <
 <eof export="" path="$PATH:/usr/local/mysql/bin" ld_library_path="$LD_LIBRARY_PATH:/usr/local/mysql/lib" eof="" usr="" local="" mysql="" bin="" mysqladmin="" -u="" root="" password="" $mysqlrootpwd="" cat="">
 /tmp/mysql_sec_script<
 <eof use="" mysql;="" delete="" from="" mysql.user="" where="" user!="root" or="" host!="localhost" ;="" grant="" all="" privileges="" on="" *.*="" to="" 'root'@'%'="" identified="" by="" 'manager';="" flush="" privileges;="" eof="" usr="" local="" mysql="" bin="" -u="" root="" -p$mysqlrootpwd="" -h="" localhost="">
 <="" tmp="" mysql_sec_script="" #rm="" -f="" #="" etc="" init.d="" mysqld="" restart="" echo="" "="===========================MySQL" 5.7.15="" install="" completed="========================"" }="" function="" checkinstall()="" {="" check="" clear="" ismysql="" "checking..."="" if="" [="" -s="" ]="" &&="" mysqld_safe="" my.cnf="" ];="" then="" "mysql:="" ok"="" else="" "error:="" not="" found!!!mysql="" failed."="" fi="" "$ismysql"="ok" "install="" completed!="" enjoy="" it."="" netstat="" -ntl="" "sorry,failed="" mysql!"="" "you="" can="" tail="" mysql-install.log="" your="" server."="" #the="" installation="" log="" initinstall="" 2="">&1 | tee /root/mysql-install.log
InstallDependsAndOpt 2>&1 | tee -a /root/mysql-install.log
InstallMySQL57 > /dev/null
CheckInstall 2>&1 | tee -a /root/mysql-install.log
 </eof>
 </eof>
 </eof>
 </eof>
 </eof></pre> 
 
 mysql 下载地址：<a href="http://dev.mysql.com/downloads/mysql/" target="_blank">http://dev.mysql.com/downloads/mysql/</a> 
 <img src="73/20161001173116_653.png" alt=""> 
 
 
<pre class="prettyprint">[root@h5 ~]# ./mysql_auto_install.sh 
=========================================================================
A tool to auto-compile & install MySQL 5.7.15 on Redhat/CentOS Linux 
=========================================================================
===========================
Please input the root password of mysql:
(Default password: MANAGER):336393
===========================
MySQL root password:336393
===========================
===========================
Install MySQL 5.7.15,Please input y
(Please input y , n):y
You will install MySQL 5.7.15

Press any key to start...or Press Ctrl+c to cancel
\S
Kernel \r on an \m

Linux h5 3.10.0-327.10.1.el7.x86_64 #1 SMP Tue Feb 16 17:03:50 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux

Memory is: 1824 MB 
错误：未安装软件包 mysql 
setenforce: SELinux is disabled
groupadd：“mysql”组已存在
useradd：用户“mysql”已存在
 100 200 300 400 500
 100 200 300 400 500
2016-10-01T15:36:10.497716Z 0 [Warning] InnoDB: New log files created, LSN=45790
2016-10-01T15:36:10.955713Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2016-10-01T15:36:11.119176Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: c78b138c-87ec-11e6-ac70-000c29227f72.
2016-10-01T15:36:11.120936Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2016-10-01T15:36:11.125374Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
mysqladmin: [Warning] Using a password on the command line interface can be insecure.
Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.
mysql: [Warning] Using a password on the command line interface can be insecure.
===================================== Check install ===================================
Checking...
MySQL: OK
Install MySQL 5.7.15 completed! enjoy it.
=========================================================================
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State 
tcp 0 0 127.0.0.1:6379 0.0.0.0:* LISTEN 
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 
tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN 
tcp6 0 0 :::3306 :::* LISTEN 
tcp6 0 0 :::22 :::* LISTEN 
tcp6 0 0 :::88 :::* LISTEN 
tcp6 0 0 ::1:25 :::* LISTEN 
[root@h5 ~]# mysql</pre> 
<pre class="prettyprint">补充：如果是全新的centos7.X 需要改动的有</pre> 
<pre class="prettyprint">SERVERID=`ip add ls eno16777736 | grep "inet " | awk '{ print $2}' | awk -F/ '{print $1"."$2}'| awk -F. '{ print $3$4}'`

<div>

</div>
centos7.X 的写法
</pre> 
<pre class="prettyprint">
<pre class="prettyprint">TYPE=Ethernet
BOOTPROTO=none
IPADDR=192.168.38.21
PREFIX=24
GATEWAY=192.168.38.2
DNS1=192.168.38.2
DEFROUTE=yes
PEERDNS=yes
PEERROUTES=yes
IPV4_FAILURE_FATAL=no
IPV6INIT=yes
IPV6_AUTOCONF=yes
IPV6_DEFROUTE=yes
IPV6_PEERDNS=yes
IPV6_PEERROUTES=yes
IPV6_FAILURE_FATAL=no
NAME=eno16777736
UUID=9662db0b-3bf3-4a03-96e7-470fc89f920d
DEVICE=eno16777736
ONBOOT=yes
</pre>
这是我的静态IP设置 
</pre> 
<pre class="prettyprint">还可以 开启防火墙</pre> 
<pre class="prettyprint">firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload

</pre> 
<pre class="prettyprint">查看端口：ss -ntl</pre>