Linux下MySQL安装的3种方式Linux下部署MySQL的三种方式，二进制方式安装、yum方式安装、docker方

二进制方式安装MySQL

下载安装包 downloads.mysql.com/archives/co…

系统版本	推荐 MySQL 版本
CentOS 7.x	MySQL 5.7 或 MySQL 8.0.28 之前
glibc < 2.28	不建议使用 MySQL 8.0.30+

开始部署

tar -xf  mysql-8.0.12-el7-x86_64.tar.gz
mv mysql-8.0.12-el7-x86_64/ mysql/
mv mysql /usr/local/
mkdir /usr/local/mysql/etc
mkdir /usr/local/mysql/data
mkdir /usr/local/mysql/logs

useradd mysql
vim /usr/local/mysql/etc/my.cnf

[mysqld]
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock

log-error=/usr/local/mysql/logs/mysqld.log
pid-file=/usr/local/mysql/logs/mysqld.pid

cd /usr/local/mysql

# 注意mysql root用户初始密码的输出
bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data 

chown -R mysql:mysql /usr/local/mysql

# 这里使用mysql/etc 目录下的my.cnf，需要修改mysql.server启动脚本。
# $bindir/mysqld_safe --defaults-file=/usr/local/mysql/etc/my.cnf --datadir="$datadir" --pid-file="$mysqld_pid_file_path" $other_args >/dev/null &

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/
/etc/init.d/mysql.server start

yum方式安装MySQL

下载rpm包或者通过yum源的方式安装即可
yum install -y mysql-server mysql mysql-common mysql-libs
初始密码在mysqld.log中寻找

docker安装MySQL

安装docker引擎

1. 安装依赖
    yum install -y yum-utils device-mapper-persistent-data lvm2
2. 添加docker yum 源
    yum-config-manager --add-repo https://mirrors.aliyun.com/docker-ce/linux/centos/docker-ce.repo
3. 修改docker-ce.repo 
    baseurl=https://mirrors.aliyun.com/docker-ce/linux/centos/7.9/$basearch/stable
4. 安装docker-ce
    yum makecache fast
    yum install docker-ce
    systemctl enable docker.service
    systemctl start docker.service
5. 建立docker用户组
6. 将当前用户加入docker用户组
    usermod -aG docker $USER
7. 测试docker是否安装正确
    docker run hello-world
8. 配置镜像加速器
    vim /etc/docker/daemon.json
    {
                  "registry-mirrors": [
                     "https://ghcr.geekery.cn",
                     "https://hub.geekery.cn",
                     "https://docker.m.daocloud.io",
                     "https://docker.rainbond.cc",
                     "https://docker.1panel.live"
                  ]
    }
9. 重新加载docker配置
    systemctl daemon-reload
    systemctl restart docker.service
10. 检查docker 加速器是否正常启用 
    docker info

拉取MySQL镜像

docker pull swr.cn-north-1.myhuaweicloud.com/iivey/mysql:8.0.23

运行docker镜像 docker run命令中， /dockerdata/mysql/db路径是宿主机的路径，需要先创建好。

docker run -itd -p 3306:3306 --name mysql8 --restart unless-stopped -v /etc/localtime:/etc/localtime -v /dockerdata/mysql/db:/var/lib/mysql -e MYSQL_DATABASE="iivey" -e MYSQL_USER="iivey" -e MYSQL_PASSWORD="mysql123" -e MYSQL_ROOT_PASSWORD="root123" swr.cn-north-1.myhuaweicloud.com/iivey/mysql:8.0.23 --default-authentication-plugin=mysql_native_password --character-set-server=utf8 --collation-server=utf8_bin