#!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