docker-compose安装MySQL
1.环境
- 系统版本:macOS Mojave
- docker版本:18.09.2
- docker-compose版本:1.23.2
2.构建目录规划
3.docker-compose.yml配置
version: '3'
services:
db:
environment:
MYSQL_ROOT_PASSWORD: "Love88me"
MYSQL_USER: "apollo"
MYSQL_PASSWORD: "Love88me"
MYSQL_DATABASE: "test"
image: "docker.io/mysql:latest"
restart: always
container_name: "mysql8.0"
volumes:
- "./db:/var/lib/mysql"
- "./conf/my.cnf:/etc/my.cnf"
ports:
- "23306:3306"
4.启动容器
# docker-compose up -d
5.查看容器启动状态
$ docker ps
# 6.进入容器
$ docker exec -it 41f3bbaa0a04 bash
root@41f3bbaa0a04:/# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.17 MySQL Community Server - GPL
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
| test |
+--------------------+
5 rows in set (0.04 sec)
mysql>