mysql5.7一键部署脚本

最新推荐文章于 2023-07-11 20:52:19 发布

?普天？

最新推荐文章于 2023-07-11 20:52:19 发布

阅读量343

点赞数 1

分类专栏： shell 文章标签： mysql

本文链接：https://blog.youkuaiyun.com/weixin_41648905/article/details/109229166

版权

shell 专栏收录该内容

7 篇文章

订阅专栏

这篇博客介绍了一个使用shell脚本实现的MySQL5.7一键部署方法，旨在简化安装过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

shell脚本，一键部署mysql5.7

#!/bin/bash

read -p "请先确认将光盘挂载到/mnt目录下，且mysql安装包mysql-boost-5.7.20.tar.gz在/opt目录下，y or n" START
[ $START == "n" ] && exit 0
#关闭防火墙关闭核心防护
systemctl stop firewalld
systemctl disable firewalld
setenforce 0
echo 'SELINUX=disable
SELINUXTYPE=targeted' > /etc/selinux/config

yum -y install vim                                     #超文本编辑器
yum -y install gcc gcc-c++ make pcre-devel expat-devel perl ncurses ncurses-devel bison cmake
useradd -s /sbin/nologin  mysql
tar zvxf /opt/mysql-boost-5.7.20.tar.gz -C /opt
cd /opt/mysql-5.7.20/
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock -DSYSCONFDIR=/etc -DSYSTEMD_PID_DIR=/usr/local/mysql -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DMYSQL_DATADIR=/usr/local/mysql/data -DWITH_BOOST=boost  -DWITH_SYSTEMD=1
make -j2 && make install
chown -R mysql:mysql /usr/local/mysql/
echo '[client]
port = 3306
default-character-set=utf8
socket = /usr/local/mysql/mysql.sock

[mysql]
port = 3306
default-character-set=utf8
socket = /usr/local/mysql/mysql.sock

[mysqld]
user = mysql
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
port = 3306
character_set_server=utf8
pid-file = /usr/local/mysql/mysqld.pid
socket = /usr/local/mysql/mysql.sock
server-id = 1
#skip-grant-tables
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,PIPES_AS_CONCAT,ANSI_QUOTES
' > /etc/my.cnf
chown mysql:mysql /etc/my.cnf
echo 'PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH' >> /etc/profile
echo 'export PATH' >> /etc/profile
source /etc/profile
cd /usr/local/mysql/
bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
cp usr/lib/systemd/system/mysqld.service /usr/lib/systemd/system/
systemctl enable mysqld
systemctl start mysqld
systemctl status mysqld
netstat -anpt | grep 3306
[ $? -eq 0 ] && echo "数据库安装完成,请及时登录修改密码，初始密码为空密码"