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
Preface In the development process, defining vari...
Specific method: Step 1: Stop the mysql service /...
1. Set CORS response header to achieve cross-doma...
1. What is the cardinality? Cardinality refers to...
Initially, multiple columns have different conten...
I can log in to MYSQL normally under the command ...
There are many attributes in CSS. Some attributes...
Upgrade background: In order to solve the vulnera...
This article example shares the specific code of ...
1. Right-click the project and select properties ...
Today, we use uniapp to integrate Echarts to disp...
Environment configuration 1: Install MySQL and ad...
Copy code The code is as follows: <html xmlns=...
First, let’s look at the GIF operation: Case 1: S...
1. Introduction to Distributed Storage System Wit...