Mysql二进制安装

最新推荐文章于 2024-09-15 08:03:51 发布

王化冰

最新推荐文章于 2024-09-15 08:03:51 发布

阅读量149

点赞数

分类专栏： script 文章标签：数据库 linux mysql

本文链接：https://blog.csdn.net/wang20110277/article/details/120686037

版权

script 专栏收录该内容

3 篇文章 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