docker-compose搭建mysql服务

docker-compose.yml示例

version: "3"
services:
  mysql:
    image: mysql:latest   #实践当前版本8.0.22
    restart: always
    container_name: mysql # 容器名
    environment:
      MYSQL_ROOT_PASSWORD: 123456
      MYSQL_USER: dmaker
      MYSQL_PASSWORD: 123456
      MYSQL_DATABASE: mysql
    volumes:
      - /etc/localtime:/etc/localtime:ro
      - ./conf/mysql:/etc/mysql/conf.d
      - ./conf/mysql-initdb.d:/docker-entrypoint-initdb.d/:ro
      - ./mysql:/var/lib/mysql
    expose:
      - '3306'
    ports:
      - '23306:3306'

配置文件示例

文件名：mysql.cnf
需搭配上面的docker-compose.yml使用

[mysqld]
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
datadir         = /var/lib/mysql
secure-file-priv= NULL

log-error	= /var/lib/mysql/error.log
## By default we only accept connections from localhost
##bind-address	= 127.0.0.1
## Disabling symbolic-links is recommended to prevent assorted security risks

# Custom config should go here
#!includedir /etc/mysql/conf.d/
character-set-server  = utf8mb4
collation-server      = utf8mb4_unicode_ci
character_set_server   = utf8mb4
collation_server       = utf8mb4_unicode_ci
max_allowed_packet=128M
explicit_defaults_for_timestamp=true
default-authentication-plugin=mysql_native_password
lower_case_table_names=1
symbolic-links=0

#slow log
log_output = table,file
slow-query-log = 1                 #开启记录慢查询日志
long_query_time = 2                #设置慢查询标准
slow-query-log-file = /var/lib/mysql/slowquery.log  #路径 
max_connections = 1000           #设置最大连接数，默认151

binlog_expire_logs_seconds=604800   #binlog的过期时间

参考文档：Linux中MySQL配置文件mysql.cnf参数说明

进入mysql容器

1、查询当前docker容器列表：

docker ps -a

找到对应的服务名称：familydata_mysql_1

2、进入docker容器中的mysql服务

docker exec -it familydata_mysql_1 bash
mysql -u用户名 -p

输入mysql账号、密码即可登录

之后正常操作

mysql数据导入导出

容器和宿主机文件互传

# 容器拷到宿主机
docker cp mycontainer:/opt/testnew/file.txt /opt/test/
# 宿主机拷到容器
docker cp /opt/test/file.txt mycontainer:/opt/testnew/

导出数据

导入数据

快速搭建MySQLWorkbench可连接的数据（版本原因）

docker run --name=mariadb -d --net=host -e MYSQL_ROOT_PASSWORD=root -v /var/lib/mysql:/var/lib/mysql mariadb:10.5.6

# user：root，password：root，port：3306