Execute initialization sql when docker mysql starts

Execute initialization sql when docker mysql starts

1. Pull the Mysql image

docker pull mysql:5.7

2. Check the mysql image

docker inspect mysql:5.7
"Entrypoint": [
 "docker-entrypoint.sh"
 ],

3. Create a directory for MySQL plugin locally

##Mount to the container/docker-entrypoint-initdb.d; 01_create_database.sql will be executed when MySQL starts
/root/mysql-5.7/init-data
  01_create_database.sql
  ##content
  create database test_database DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
  grant all privileges on `test_database`.* to 'test_user'@'%' identified by '123456';
  flush privileges;

##Mount to the container /var/lib/mysql
/root/mysql-5.7/mysql

4. Start mysql

docker run -p 33336:3306 -v /root/mysql-5.7/mysql:/var/lib/mysql -v /root/mysql-5.7/init-data:/docker-entrypoint-initdb.d -e MYSQL_ROOT_PASSWORD=123456 --name mysql_5.7 -d mysql/mysql:5.7

5. Enter the container, log in to mysql, and check that the library test_database has been created

docker exec -ti <containerID> sh
mysql -uroot -p123456
show databases;

Summarize

The above is what I introduced to you about how to execute initialization sql when docker mysql starts. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!
If you find this article helpful, please feel free to reprint it and please indicate the source. Thank you!

You may also be interested in:
  • Docker starts MySQL configuration implementation process
  • How to automatically execute SQL statements when MySQL in Docker starts
  • Solution to MySQL initialization and startup failure in Docker
  • How to quickly start MySQL testing using Docker on Mac
  • How to initialize the Mysql database when the Docker container starts
  • Docker starts the mysql service implementation steps

<<:  Several magical uses of JS ES6 spread operator

>>:  Detailed installation process of mysql5.7.21 under win10

Recommend

Five solutions to cross-browser problems (summary)

Brief review: Browser compatibility issues are of...

Complete steps to use samba to share folders in CentOS 7

Preface Samba is a free software that implements ...

Vue implements chat interface

This article example shares the specific code of ...

Ubuntu terminal multi-window split screen Terminator

1. Installation The biggest feature of Terminator...

Using Docker to create static website applications (multiple ways)

There are many servers that can host static websi...

Detailed tutorial on configuring local yum source in CentOS8

The centos8 distribution is released through the ...

Practical record of optimizing MySQL tables with tens of millions of data

Preface Let me explain here first. Many people on...

Detailed explanation of the usage of two types of temporary tables in MySQL

External temporary tables A temporary table creat...

Windows10 mysql 8.0.12 non-installation version configuration startup method

This article shares the specific steps for config...

A simple LED digital clock implementation method in CSS3

This should be something that many people have do...

Detailed explanation of nginx installation, deployment and usage on Linux

Table of contents 1. Download 2. Deployment 3. Ng...

How to modify the IP restriction conditions of MySQL account

Preface Recently, I encountered a requirement at ...

Detailed tutorial on installation and configuration of nginx under Centos7

Note: The basic directory path for software insta...