mysql 5.6.36 jdbc_mysql5.6.36版本一键部署脚本

#!bin/bash

#2019-09-30

#V1.0

#安装mysql

whiptail --title "安装 mysql数据库" --msgbox " 开始安装mysql-5.6.36版本! " 10 60

spPath=$(cd `dirname $0`; pwd)

cd $spPath

echo "正在移除系统自带mariadb！"

for mar in `rpm -qa|grep mariadb`

do

rpm -e $mar --nodeps

done

echo "开始解压mysql安装包!"

tar -xvf ${spPath}/software/mysql-5.6.36-linux-glibc2.5-x86_64.tar.gz -C /usr/local > /dev/null

mv /usr/local/mysql-5.6.36-linux-glibc2.5-x86_64 /usr/local/mysql

groupadd mysql

useradd -g mysql mysql

cd /usr/local/mysql

chown -R root:root ./

chown -R mysql:mysql data

cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql

#设置环境变量

echo 'PATH=/usr/local/mysql/bin/:$PATH' >>/etc/profile

source /etc/profile

echo $PATH

#安装安装autoconf环境

rpm -ivh ${spPath}/software/perl-Data-Dumper-2.145-3.el7.x86_64.rpm

cd /usr/local/mysql

./scripts/mysql_install_db --user=mysql

ln -s /usr/local/mysql/bin/mysql /usr/bin

echo "开始启动mysql服务!"

service mysql start

#设置开机自启

chkconfig mysql on

#设置数据库root密码

PASSWD="visionvera"

mysql -uroot -e "set password=password('$PASSWD');"

mysql -uroot -p$PASSWD -e "create user root@'%' identified by 'visionvera';grant all privileges on *.* to root@'%';flush privileges;"

echo "安装完成，数据库root密码为“visionvera”!"

#开放系统防火墙3306端口

systemctl status firewalld.service > /dev/null

if [ $? != 0 ];then

echo "防火墙未开启，不做配置。"

else

systemctl enable firewalld.service

firewall-cmd --zone=public --add-port=3306/tcp --permanent > /dev/null

firewall-cmd --reload > /dev/null

echo "防火墙已放行3306端口"

fi

注：环境包下载地址：链接: https://pan.baidu.com/s/1xfCzKrlOH-zzUPw3smWanQ

提取码: dq2p