docker-compose之mysql的安装

1.在mysql目录下，新建docker-compose-mysql.yml文件

[root@abc mysql]# pwd /home/middleware/mysql [root@abc mysql]# cat docker-compose-mysql.yml version: '2.0' services: mysql: image: mysql:latest container_name: mysql8.0 restart: always command: --default-authentication-plugin=mysql_native_password ports: - 3306:3306 volumes: - /etc/localtime:/etc/localtime:ro - /home/middleware/mysql/data:/var/lib/mysql - /home/middleware/mysql/logs:/var/log/mysql - /home/middleware/mysql/conf:/etc/mysql - /home/middleware/mysql/init:/docker-entrypoint-initdb.d network_mode: "bridge" environment: MYSQL_ROOT_PASSWORD: 123456 MYSQL_USER: lee MYSQL_PASS: 123456

 2.根据定义的yml文件新建conf文件夹，并在文件夹下新建my.cnf的文件，文件内容如下

[root@abc conf]# pwd /home/middleware/mysql/conf [root@abc conf]# ls my.cnf [root@iZwz93g1c5ttsmy1iwxnveZ conf]# cat my.cnf [mysqld] user=mysql character-set-server=utf8 default_authentication_plugin=mysql_native_password secure_file_priv=/var/lib/mysql expire_logs_days=7 sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION max_connections=1000 secure_file_priv=/var/lib/mysql [client] default-character-set=utf8 [mysql] default-character-set=utf8

3.启动mysql,并查看是否启动。

[root@abc mysql]# docker-compose -f docker-compose-mysql.yml up -d [root@abc mysql]# docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES bbcc53579b70 mysql:latest "docker-entrypoint.s…" 31 minutes ago Up 9 minutes 0.0.0.0:3306->3306/tcp, 33060/tcp mysql8.0 2fccecdd4502 jenkins/jenkins:lts "/sbin/tini -- /usr/…" About an hour ago Up About an hour 0.0.0.0:8080->8080/tcp, 0.0.0.0:50000->50000/tcp jenkins 33494b7bb2c9 redis:latest "docker-entrypoint.s…" 2 hours ago Up 2 hours 0.0.0.0:6379->6379/tcp redis4.0