docker-compose启动mysql、mssql
mysql docker-compose.yaml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
| services:
mysql:
image: mysql:8.0
container_name: mysql8
environment:
MYSQL_ROOT_PASSWORD: "P@ssw0rd"
ports:
- "3306:3306"
command:
- --default-authentication-plugin=mysql_native_password
- --character-set-server=utf8mb4
- --collation-server=utf8mb4_general_ci
volumes:
- ./data:/var/lib/mysql # 持久化数据库数据
- ./conf/my.cnf:/etc/mysql/my.cnf
- ./logs:/var/log/mysql
restart: unless-stopped # 重启策略
|
mysql配置
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
| [mysqld]
user=mysql
# 表示允许任何主机登陆MySQL
bind-address = 0.0.0.0
port=3306
default-storage-engine=INNODB
#character-set-server=utf8
character-set-client-handshake=FALSE
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
secure-file-priv=
[client]
default-character-set=utf8mb4
[mysql]
default-character-set=utf8mb4
|
mssql docker-compose.yaml
1
2
3
4
5
6
7
8
9
10
11
12
| services:
mssql:
image: mcr.microsoft.com/mssql/server:2022-latest
container_name: mssql2022
environment:
- ACCEPT_EULA=Y
- MSSQL_SA_PASSWORD=P@ssw0rd
ports:
- "1433:1433"
volumes:
- /software/mssql/data:/var/opt/mssql
restart: always
|
