linux下安装MYSQL5.7一步完成

#    下载安装包后，执行此脚本。

#    数据库目录/usr/local/mysql

#     数据目录/data/mysql 
#     慢日志目录/data/slowlog 
#     端口号默认3306其余参数按需自行修改  
  #   mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz 放在 /usr/local/ 
  #   安装完 iptables -I INPUT -p tcp --dport 3306 -j ACCEPT
  #   mysql 进入后   (mysql -p)
  #      >>grant all privileges on *.* to 'root'@'%' identified by 'root' with grant option;
  #      >>flush privileges;
  #      >>update mysql.user set authentication_string=password('kxstar') where user='root';
  #      >>flush privileges;
  
  #    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
#             是因为忘记密码了。。
#             最简单方式：/etc/mysql/my.cnf 或/etc/my.cnf
#             加入skip-grant-tables
#             重启mysql服务:service mysqld restart
#             可以直接进入：mysql -u root
#             执行改密码：update mysql.user set authentication_string=password('kxstar') where user='root';
#             把my.cnf中的skip-grant-tables去掉，重启服务
  
#!/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 


# kx1
tar xvf /usr/local/mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz 
# kx2
mv /usr/local/mysql-5.7.19-linux-glibc2.12-x86_64 /usr/local/mysql
groupadd mysql -g 512 
useradd -u 512 -g mysql -s /sbin/nologin -d /home/mysql mysql 
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 eth0 | grep "inet addr" | 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=1
#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=75 
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 
  #scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --ldata=/var/lib/mysql
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 
iptables -I INPUT -p tcp --dport 3306 -j ACCEPT
#iptables -I INPUT -p tcp --dport 3306 -j ACCEPT
  
  
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 'sys_admin'@'%' identified by 'MANAGER'; 
flush privileges; 
grant all privileges on *.* to 'root'@'%' identified by 'root' with grant option;
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