Linux一键自动安装mysql 5.6

#! /bin/bash
# 2020年7月10日23:49:10
# auto install mysql database
# version v2
# by author jie
#####################################
echo "定义变量"
YUM_REPO_BASE="http://mirrors.163.com/.help/CentOS7-Base-163.repo"
YUM_REPO_EPEL="http://mirrors.aliyun.com/repo/epel-7.repo"
MYSQL_VER="mysql-5.6.45.tar.gz"
MYSQL_MC="mysql-5.6.45"
MYSQL_YUM="yum -y install"
MYSQL_YILAI="git gcc gcc-c++ ncurses ncurses-devel make cmake libaio bison openssl openssl-devel"
MYSQL_URL="http://mirrors.163.com/mysql/Downloads/MySQL-5.6/mysql-5.6.45.tar.gz"
MYSQL_BASEDIR="/usr/local/mysql/"
MYSQL_DATADIR="/data/mysql/"
MYSQL_CNF="/etc/my.cnf"
echo "安装网易源及epel源"
wget -P /etc/yum.repos.d $YUM_REPO_BASE
wget -O /etc/yum.repos.d/epel.repo $YUM_REPO_BASE
yum clean all
yum makecache
echo "安装软件依赖环境"
$MYSQL_YUM $MYSQL_YILAI
echo "下载数据库"
wget -c $MYSQL_URL
tar -zxvf $MYSQL_VER
cd $MYSQL_MC
echo "创建数据库安装base目录"
mkdir -p $MYSQL_BASEDIR
echo "创建数据目录"
mkdir -p $MYSQL_DATADIR
useradd -M -s /sbin/nologin -r mysql
chown -R mysql. $MYSQL_DATADIR
pwd
echo "预编译"
cmake . -DCMAKE_INSTALL_PREFIX=$MYSQL_BASEDIR \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
-DMYSQL_DATADIR=$MYSQL_DATADIR \
-DSYSCONFDIR=/etc \
-DMYSQL_USER=mysql \
-DMYSQL_TCP_PORT=3306 \
-DWITH_XTRADB_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_EXTRA_CHARSETS=1 \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DEXTRA_CHARSETS=all \
-DWITH_BIG_TABLES=1 \
-DWITH_DEBUG=0
echo "编译及安装"
make && make install
echo "新建启动二进制文件"
cp support-files/mysql.server /etc/init.d/mysqld
chmod 755 /etc/init.d/mysqld
echo "给二进制文件加可执行文件"
chmod +x /etc/init.d/mysqld
echo "配置my.cnf文件"
cat > $MYSQL_BASEDIR/my.cnf<<EOF
[client]
port        = 3306
socket      = /tmp/mysql.sock
[mysqld]
port = 3306
user = mysql
tmpdir = /tmp
basedir = /usr/local/mysql/
datadir = /data/mysql/
pid-file = /data/mysql/mysql.pid
socket = /tmp/mysql.sock
[mysql_safe]
log-error = /data/mysql/error.log
EOF
echo "复制my.cnf"
cp -rf $MYSQL_BASEDIR/my.cnf $MYSQL_CNF
chmod 755 $MYSQL_CNF
echo "初始化数据库"
/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=$MYSQL_BASEDIR --datadir=$MYSQL_DATADIR --defaults-file=$MYSQL_CNF
echo "设置环境变量"
echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
source /etc/profile
echo $PATH
echo "将mysql设置为系统服务"
chkconfig --level 35 mysqld on
chkconfig --add mysqld
echo "关闭启动数据库"
/etc/init.d/mysqld start
echo "查看进程"
ps -ef | grep mysqld
echo "查看端口"
netstat -ntlp | grep mysqld 
echo "查看mysql运行状态"                       
systemctl status mysqld


验证：
![在这c里插入图片描述](https://img-blog.csdnimg.cn/20200712100649728.png)
 **~~仅供个人学习参考~~ **