MySQL 5.7 8.0 一键安装shell脚本

Asui2233

已于 2024-01-10 18:51:45 修改

阅读量99

点赞数

分类专栏： MySQL 文章标签： mysql 数据库运维

于 2023-09-27 10:24:00 首次发布

本文链接：https://blog.csdn.net/weixin_44965990/article/details/133342069

版权

MySQL 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

#!/bin/bash
rpm -q libaio > /dev/null || yum install libaio -y > /dev/null 2>&1
if id -g mysql > /dev/null 2>&1
then
    echo 'mysql group exists'
else
    groupadd mysql > /dev/null 2>&1 && echo 'creating mysql group success'
fi
if id -u mysql > /dev/null 2>&1
then
    echo 'mysql user exists'
else
    useradd -r -g mysql -s /sbin/nologin mysql > /dev/null 2>&1 && echo 'creating mysql user success'
fi
src_binary_dir=/pkg/mysql
install_dir=/usr/local
mydatadir=/opt/mysql
[ -d $mydatadir ] || mkdir -p $mydatadir
echo -n "Enter you version of MySQL: "
read version
cd ${src_binary_dir}/${version}
tar -zxf $(/usr/bin/ls mysql*.tar.gz) -C ${install_dir}
cd ${install_dir}
ln -s $(ls -d mysql-${version}*) mysql
echo 'export PATH=/usr/local/mysql/bin:$PATH' > /etc/profile.d/mysql.sh

cat << EOF > /etc/my.cnf
[mysql]
prompt=(\\u@\\h) [\\d]>\\_
[mysqld]
port = 3306
user = mysql
datadir = /opt/mysql/data
log_error = error.log
log_timestamps = system
EOF

cd mysql
case $version in
    8.0)
	    chmod 750 $mydatadir
	    chown mysql:mysql $mydatadir
	    bin/mysqld --initialize --user=mysql > /dev/null 2>&1
	    [ $? -eq 0 ] && echo "Installing mysql-server success"
	    chown -R root:mysql .
	    cp support-files/mysql.server /etc/init.d/mysql.server
	    grep "temporary password" $mydatadir/data/error.log | awk -F: '{print $5}' > /tmp/mypass.txt
	    systemctl enable mysql.server > /dev/null 2>&1
	    ;;
    5.7)
        chmod 750 $mydatadir
	    chown mysql:mysql $mydatadir
	    bin/mysqld --initialize --user=mysql > /dev/null 2>&1
	    [ $? -eq 0 ] && echo "Installing mysql-server success"
	    chown -R root:mysql .
	    cp support-files/mysql.server /etc/init.d/mysql.server
	    grep "temporary password" $mydatadir/mysql_test_data/error.log |  awk -F: '{print $4}' > /tmp/mypass.txt
	    systemctl enable mysql.server > /dev/null 2>&1
	    ;;
	5.6)
	    sed -i '/log_timestamps/d' /etc/my.cnf
	    scripts/mysql_install_db --user=mysql > /dev/null 2>&1
	    [ $? -eq 0 ] && echo "Installing mysql-server success"
	    chown -R root:mysql .
	    cp support-files/mysql.server  /etc/init.d/mysql.server
	    systemctl enable mysql.server > /dev/null 2>&1
	    ;;
esac