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

Causes and solutions for slow MySQL queries

There are many reasons for slow query speed, the ...

Some slightly more complex usage example codes in mysql

Preface I believe that the syntax of MySQL is not...

Implementation code for using CSS text-emphasis to emphasize text

1. Introduction In the past, if you wanted to emp...

How to deploy Node.js with Docker

Preface Node will be used as the middle layer in ...

Detailed explanation of 4 common data sources in Spark SQL

Generic load/write methods Manually specify optio...

Summary of essential knowledge points for MySQL query optimization

Preface Query optimization is not something that ...

JavaScript anti-shake and throttling detailed explanation

Table of contents Debounce Throttle Summarize Deb...

MySQL 8.0.24 installation and configuration method graphic tutorial

This article shares the installation tutorial of ...

How to add and delete unique indexes for fields in MySQL

1. Add PRIMARY KEY (primary key index) mysql>A...

Detailed explanation of Linux zabbix agent deployment and configuration methods

1. Install zabbix-agent on web01 Deploy zabbix wa...