一键安装mysql-5.6二进制包脚本

 1[root@vm-template ~]#cat mysql-install.sh 
 2#!/bin/bash
 3DIR=`pwd`
 4NAME="mysql-5.6.42-linux-glibc2.12-x86_64.tar.gz"
 5FULL_NAME=${DIR}/${NAME}
 6DATA_DIR="/data/mysql"
 7
 8yum install vim gcc gcc-c++ wget autoconf  net-tools lrzsz iotop lsof iotop bash-completion -y
 9yum install curl policycoreutils openssh-server openssh-clients postfix -y
10
11if [ -f ${FULL_NAME} ];then
12    echo "安装文件存在"
13else
14    echo "安装文件不存在"
15    exit 3
16fi
17if [ -h /usr/local/mysql ];then
18    echo "Mysql 已经安装"
19    exit 3 
20else
21    tar xvf ${FULL_NAME}   -C /usr/local/src
22    ln -sv /usr/local/src/mysql-5.6.42-linux-glibc2.12-x86_64  /usr/local/mysql
23    if id  mysql;then
24        echo "mysql 用户已经存在，跳过创建用户过程"
25    fi
26        useradd  mysql  -s /sbin/nologin
27    if  id  mysql;then
28        chown  -R mysql.mysql  /usr/local/mysql/* -R
29        if [ ! -d  /data/mysql ];then
30            mkdir -pv /data/mysql /var/lib/mysql && chown  -R mysql.mysql  /data   -R
31            /usr/local/mysql/scripts/mysql_install_db  --user=mysql --datadir=/data/mysql  --basedir=/usr/local/mysql/
32            cp  /usr/local/src/mysql-5.6.42-linux-glibc2.12-x86_64/support-files/mysql.server /etc/init.d/mysqld
33            chmod a+x /etc/init.d/mysqld
34            cp ${DIR}/my.cnf   /etc/my.cnf
35            ln -sv /usr/local/mysql/bin/mysql  /usr/bin/mysql
36            ln -sv /data/mysql/mysql.sock  /var/lib/mysql/mysql.sock
37            /etc/init.d/mysqld start
38        else
39            echo "MySQL数据目录已经存在,"
40                        exit 3
41        fi
42    fi
43fi
44
45
46[root@vm-template ~]#cat my.cnf 
47[mysqld]
48socket=/data/mysql/mysql.sock
49user=mysql
50symbolic-links=0
51datadir=/data/mysql
52innodb_file_per_table=1
53max_connections=10000
54
55[client]
56port=3306
57socket=/var/lib/mysql/mysql.sock
58
59[mysqld_safe]
60log-error=/var/log/mysqld.log
61pid-file=/tmp/mysql.sock

 1[root@vm-template ~]#mysql --version
 2mysql  Ver 14.14 Distrib 5.6.42, for linux-glibc2.12 (x86_64) using  EditLine wrapper
 3[root@vm-template ~]#mysql
 4Welcome to the MySQL monitor.  Commands end with ; or \g.
 5Your MySQL connection id is 3
 6Server version: 5.6.42 MySQL Community Server (GPL)
 7
 8Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
 9
10Oracle is a registered trademark of Oracle Corporation and/or its
11affiliates. Other names may be trademarks of their respective
12owners.
13
14Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
15
16mysql>