mysql 5.7 自动安装_mysql5.7 shell自动安装

最新推荐文章于 2024-01-11 12:47:30 发布

韩站长

最新推荐文章于 2024-01-11 12:47:30 发布

阅读量114

点赞数

文章标签： mysql 5.7 自动安装

本文链接：https://blog.csdn.net/weixin_36236823/article/details/113421928

版权

cat mysql.sh

#!/bin/sh

#auto install mysql5.7.10

#setting default directory

Port=$1

SoftDir="/opt/install"

tarbag="mysql-5.7.10-linux-glibc2.5-x86_64"

BaseDir="/opt/mysql"

DataDir="/opt/$Port"

mkdir -p /usr/local/mysql/data

#remove before being installed mysql

function rmMysql() {

yum -y erase mysql >/dev/null 2>&1

yum -y erase mysql-server >/dev/null 2>&1

ret=`rpm -aq | grep -i "mysql-5" | wc -l`

num=`rpm -aq | grep -i "mysql-server" | wc -l`

test $ret -eq 1 && echo "mysql uninstall failed" && exit 1

test $num -eq 1 && echo "mysql-server uninstall failed" && exit 2

}

#libaio package is needed for mysql5.7.10

function chkEnv() {

yum -y install libaio >/dev/null 2>&1

res=`rpm -aq|grep libaio | wc -l`

test $res -ne 1 && echo "libaio package install failed..." && exit 3

}

#create mysql user and group, authorization, extract

function preInstall() {

/usr/sbin/groupadd mysql

/usr/sbin/useradd -r -g mysql -s /bin/false mysql

mkdir -p $BaseDir

mkdir -p $DataDir/data

chown mysql.mysql $DataDir

if test -f $SoftDir/$tarbag.tar.gz

then

cd $SoftDir && tar -zxf $tarbag.tar.gz

cd $SoftDir/$tarbag && cp -r * $BaseDir

echo ok

else

echo "$tarbag.tar.gz is not found..."

exit 10

}

function multPreInstall() {

mkdir -p $DataDir/data

chown mysql.mysql $DataDir

}

function install_mysql() {

#initialize mysql database

$BaseDir/bin/mysqld \

--initialize \

--user=mysql \

--basedir=$BaseDir \

--datadir=$DataDir/data \

--character-set-server=utf8mb4 \

--collation-server=utf8mb4_general_ci \

--initialize-insecure >/dev/null 2>&1

}

#get my.cnf and start/stop script, attention alter parameters by your envionment

function conf_mysql() {

cp $SoftDir/my.cnf $DataDir

cp $SoftDir/mysql.server $DataDir

/usr/bin/vim $DataDir/my.cnf</dev/null 2>&1

:%s/3306/$Port/g

:wq

EOF

sed -i "s/port=3306/port=$Port/" $DataDir/mysql.server

sed -i "s%CmdPath=\"\"%CmdPath=\"${BaseDir}\/bin\"%" $DataDir/mysql.server

sed -i "s%mysql_sock=\"\"%mysql_sock=\"${DataDir}\/mysql.sock\"%" $DataDir/mysql.server

chmod 600 $DataDir/my.cnf

chmod 700 $DataDir/mysql.server

$DataDir/mysql.server start >/dev/null 2>&1

sleep 60

# ren=`netstat -natp|grep mysqld | grep "$1" | wc -l`

if test -e $DataDir/mysql.sock;then

echo "$DataDir/mysql.sock"

echo -e "\033[33;1mmysql install success...\033[0m"

pro=`grep $BaseDir /root/.bash_profile | wc -l`

if test "$pro" -ne 1;then

# sed -i "s%PATH=\$PATH\:\$HOME\/bin%PATH=\$PATH\:\$HOME\/bin\:$BaseDir\/bin%" /root/.bash_profile

sed -i "s%PATH=\$PATH\:\$HOME\/bin%PATH=\$HOME\/bin\:$BaseDir\/bin%:\$PATH" /root/.bash_profile

source /root/.bash_profile

else

echo -e "\033[31;1mmysql install failed...\033[0m"

}

if [[ "$1" =~ ^[0-9]+$ ]]; then

inPort=`netstat -natp | grep "mysqld" | grep "LISTEN" | awk '{print $4}' | cut -b 4-`

if test ! -z "$inPort";then

for myPort in $inPort

if test "$myPort" -eq "$1";then

echo -e "\033[33;1m$1 instance has already existed...\033[0m"

exit 1

done