1. Pull the Mysql image 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! You may also be interested in:
|
<<: Several magical uses of JS ES6 spread operator
>>: Detailed installation process of mysql5.7.21 under win10
Brief review: Browser compatibility issues are of...
Preface Samba is a free software that implements ...
This article example shares the specific code of ...
1. Installation The biggest feature of Terminator...
Situation description: The database was started a...
There are many servers that can host static websi...
The centos8 distribution is released through the ...
Preface Let me explain here first. Many people on...
External temporary tables A temporary table creat...
This article shares the specific steps for config...
This should be something that many people have do...
Table of contents 1. Download 2. Deployment 3. Ng...
Preface Recently, I encountered a requirement at ...
Table of contents Preface What are dynamic proper...
Note: The basic directory path for software insta...