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
There are many reasons for slow query speed, the ...
Preface I believe that the syntax of MySQL is not...
1. Install Docker yum -y install docker-io The &q...
Table of contents 1. Event delegation Event Bubbl...
1. Introduction In the past, if you wanted to emp...
Preface Node will be used as the middle layer in ...
Generic load/write methods Manually specify optio...
Preface Query optimization is not something that ...
As shown below: 1. ssh -v -p [port number] [user ...
To implement the "Enter != Submit" probl...
Table of contents Debounce Throttle Summarize Deb...
This article shares the installation tutorial of ...
vsftpd Overview vsftpd is the abbreviation of &qu...
1. Add PRIMARY KEY (primary key index) mysql>A...
1. Install zabbix-agent on web01 Deploy zabbix wa...