Mysql 5.7安装
目录
一、Mysql yum 安装
## 系统环境Centos 7.8
## MySQL GPG 密钥已过期解决方案
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
# 从官网下载rpm
wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
yum localinstall mysql57-community-release-el7-8.noarch.rpm -y
yum repolist enabled | grep "mysql.*-community.*"
yum install mysql-community-server -y
配置和启动mysql server
cat <<EOF >> /etc/my.cnf
character_set_server=utf8
init_connect='SET NAMES utf8'
innodb_file_per_table=1
sql_mode='STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION'"
EOF
#启动
systemctl start mysqld
#查看MySQL的启动状态
systemctl status mysqld
#开机启动
systemctl enable mysqld
systemctl daemon-reload
二、Mysql Docker安装
port=3306
### 创建文件夹 ###
mkdir -p /docker/mysql/$port/logs
mkdir -p /docker/mysql/$port/data
mkdir -p /docker/mysql/$port/conf
### 复制配置文件 ###
cp -r ./mysql /docker/mysql/$port/conf/
###启动docker mysql###
docker run -d \
-p $port:3306 \
--restart="always" \
--name mysql_$port \
-v /docker/mysql/$port/logs:/var/log/mysql \
-v /docker/mysql/$port/data:/var/lib/mysql \
-v /docker/mysql/$port/conf/mysql:/etc/mysql:Z \
-e MYSQL_ROOT_PASSWORD='Root123456' \
mysql:5.7