Mysql二进制安装-蒲公英云

Mysql二进制安装

梦里梦外; 2022-09-15 06:04 297阅读 0赞

上干货：

#!/bin/bash
MYSQL_TYPE=5.7
MYSQL_VER=5.7.24-linux-glibc2.12-x86_64
PORT=3306
TOOLS_DIR=/home/sunbox/soft
INSTALL_DIR=/usr/local
ROOTPWD=password@123456
# Check if user is root
if [ $(id -u) != "0" ]; then
    echo "Error: You must be root to run this script, please use root to install"
    exit 1
fi
# Check network environmental
#NET_NUM=`ping -c 4 www.baidu.com |awk '/packet loss/{print $6}' |sed -e 's/%//'`
#if [ -z "$NET_NUM" ] || [ $NET_NUM -ge 10 ];then
#        echo "Please check your internet"
#        exit 1
#fi
#Backup old my.cnf
if [ -s /etc/my.cnf ]; then
    mv /etc/my.cnf /etc/my.cnf.`date +%Y%m%d%H%M%S`.bak
fi
#安装编译工具
yum install gcc gcc-c++ ncurses ncurses-devel openssl openssl-devel libtool* cmake
[ ! -d $TOOLS_DIR ] && mkdir -pv $TOOLS_DIR
cd $TOOLS_DIR
if [ ! -f mysql-${MYSQL_VER}.tar.gz ]; then
    wget http://47.92.71.36:28801/mysql-${MYSQL_VER}.tar.gz
fi
tar xvf mysql-${MYSQL_VER}.tar.gz -C $INSTALL_DIR
cd $INSTALL_DIR
[ ! -e $INSTALL_DIR/mysql ] && ln -sv $INSTALL_DIR/mysql-${MYSQL_VER} $INSTALL_DIR/mysql
#edit /etc/my.cnf
cat >>/etc/my.cnf<<EOF
[mysqld]
port=$PORT
#设置安装目录
basedir=/usr/local/mysql
# 设置mysql数据库的数据的存放目录
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
user=mysql
tmpdir=/tmp
# 开启ip绑定
bind-address=0.0.0.0
# 允许最大连接数
max_connections=1000
# 服务端使用的字符集默认为8比特编码的latin1字符集
character-set-server=utf8mb4
collation-server=utf8mb4_general_ci
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB
innodb_buffer_pool_size=64MB
max_allowed_packet=16M
log-error=/usr/local/mysql/data/error.log
[mysqld_safe]
pid-file=/usr/local/mysql/data/mysql.pid
[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8mb4
[client]
#指定客户端连接mysql时的socket通信文件路径
socket=/tmp/mysql.sock
default-character-set=utf8mb4
EOF
#创建mysql用户和组
groupadd mysql
useradd -r -g mysql mysql
mkdir -p $INSTALL_DIR/mysql/data
cd $INSTALL_DIR/mysql
chown -R mysql:mysql $INSTALL_DIR/mysql-${MYSQL_VER}
chown -R mysql:mysql $INSTALL_DIR/mysql
#Compile mysql
$INSTALL_DIR/mysql/bin/mysqld --user=mysql --basedir=$INSTALL_DIR/mysql --datadir=$INSTALL_DIR/mysql/data --initialize
cp $INSTALL_DIR/mysql/support-files/mysql.server /etc/init.d/mysqld
chkconfig --add mysqld
cat>>/etc/profile.d/mysql.sh<<EOF
export PATH=$PATH:$INSTALL_DIR/mysql/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$INSTALL_DIR/mysql/lib
EOF
source /etc/profile.d/mysql.sh
firewall-cmd --add-port=$PORT/tcp --permanent
firewall-cmd --reload
service mysqld start
Pass=$(grep 'A temporary password' $INSTALL_DIR/mysql/data/error.log | awk '{print $NF}')
echo '临时密码：'$Pass
/usr/local/mysql/bin/mysqladmin -uroot -p$Pass password $ROOTPWD
cat >>/tmp/mysql_script<<EOF
use mysql;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'sunbox@tbd7';
CREATE USER 'root'@'%' IDENTIFIED BY 'sunbox@tbd7';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'sunbox@tbd7' WITH GRANT OPTION;
FLUSH PRIVILEGES;
EOF
/usr/local/mysql/bin/mysql -uroot -p$ROOTPWD -h localhost < /tmp/mysql_script