How to use Docker-compose to deploy mysql

1. Introduction to Docker-compose

Restated: For most people, the most important role of a container orchestration tool may be as a script to start a container. It can start multiple containers at one time, and its automatic container restart strategy is also very useful.

2. Deployment steps

1. Create a new directory docker-compose in the /root directory, and create a new mysql file in the /root/docker-compose directory

cd /root 
mkdir docker-compose && cd docker-compose
mkdir mysql && cd mysql

2 Prepare to mount the file

(If you do not need to modify the configuration file, you can skip this step, and then delete the mounting of the configuration file when the docker-compose.yml file is mounted)

In /root/ Create a new config folder under the docker-compose/mysql folder, and create a new my.cnf file under the conf file

mkdir config && cd config
vim my.cnf

Copy the following configuration file to my.cnf

[mysqld]
user=mysql
default-storage-engine=INNODB
character-set-server=utf8
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8

3. Write docker-compose.yml file

Create a new docker-compose.yml file in the /root/docker-compose/mysql folder,

cd /root/docker-compose/mysql

vim docker-compose.yml

Add the following content and copy it to docker-compose.yml

version: '3'
services:
  mysql:
    image: mysql
    restart: always
    container_name: mysql
    environment:
      MYSQL_ROOT_PASSWORD: password
      TZ: Asia/Shanghai
    ports:
      - 3306:3306
    volumes:
      - /root/docker-compose/mysql/data:/var/lib/mysql
      - /root/docker-compose/mysql/config/my.cnf:/etc/mysql/my.cnf
    command:
      --max_connections=1000
      --character-set-server=utf8mb4
      --collation-server=utf8mb4_general_ci
      --default-authentication-plugin=mysql_native_password

Note that line 8 of docker-compose.yml sets the password for mysql root account login. Just change the password here to the password you need.

4. Start

docker-compose up -d

The above is the detailed content of How to use Docker-compose to deploy mysql. For more information, please follow other related articles on the PHP Chinese website!