Docker 安装 MySQL8 数据库

合集 - Docker-常用服务安装(4)

1.Docker 安装 MySQL8 数据库2023-06-12

2.Docker 安装 Redis2023-06-133.Docker 安装与升级2023-06-124.Docker 安装 Nacos 注册中心2023-06-16

收起

创建数据卷

mkdir -p /usr/mysql/conf /usr/mysql/data

chmod -R 755 /usr/mysql/

创建配置文件

vim /usr/mysql/conf/my.cnf:

[client]

#socket = /usr/mysql/mysqld.sock

default-character-set = utf8mb4

[mysqld]

#pid-file        = /var/run/mysqld/mysqld.pid

#socket          = /var/run/mysqld/mysqld.sock

#datadir         = /var/lib/mysql

#socket = /usr/mysql/mysqld.sock

#pid-file = /usr/mysql/mysqld.pid

datadir = /usr/mysql/data

character_set_server = utf8mb4

collation_server = utf8mb4_bin

secure-file-priv= NULL

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

# Custom config should go here

!includedir /etc/mysql/conf.d/

创建容器

docker run --name mysql8 --restart=always -v /usr/mysql/conf/my.cnf:/etc/mysql/my.cnf -v /usr/mysql/data:/var/lib/mysql -v /etc/localtime:/etc/localtime:ro -p 3310:3306 -e MYSQL_ROOT_PASSWORD=bntang -d mysql:8

添加用户

docker exec -it mysql8 /bin/bash

# 创建 bntang 用户，密码为 bntang，允许在任意机器上登录
CREATE USER 'bntang'@'%' IDENTIFIED BY 'bntang';

# 赋予 bntang 用户在 所有机器上 对 所有数据库和数据表 拥有 所有操作权限
GRANT ALL ON *.* TO 'bntang'@'%';

MySQL 5.7

docker run -itd --name="mysql" -p3307:3306 -v /root/mydata/mysql/conf/:/etc/mysql/conf.d -v /root/mydata/mysql/data:/var/lib/mysql -v /root/mydata/mysql/logs:/var/log -e MYSQL_ROOT_PASSWORD="1234" mysql:5.7

grant all privileges on *.* to 'root'@'%' identified by '1234'