Assuming you have completed docker installation on windows and registered with oracle container registry, Read first part here if not yet done
This post explain how to create a container for mysql and also show some example of managing container etc. In less than 10 mins mysql database is ready and you can practice what ever you like.
Pull Docker Image and Run the docker with default options
docker pull container-registry.oracle.com/mysql/community-server
Run the docker with mysql image, I have kept the root password and name of docker is mysql5.7
docker run --name mysql5.7 -e MYSQL_ROOT_PASSWORD=sayit -d container-registry.oracle.com/mysql/community-server:lates
Login to Shell
docker exec -it mysql5.7 bash
Getting connected outside from the docker use -p or -P option while run the docker command
Once logged in , show databases and create databases etc and rest of things will be as usual.
Stop docker container
docker stop mysql5.7
Start docker container
docker start mysql5.7
Remove docker container, you can use -f option to forcefully delete the running docker
docker rm mysql5.6 -f
Further, if you want to keep any additional parameter you can use a cnf file and run the docker run command, this file will replace the cnf file in the docker container 🙂
The MySQL startup configuration in these Docker images is specified in the file /etc/my.cnf. If you want to customize this configuration for your own purposes, you can create your alternative configuration file in a directory on the host machine and then mount this file in the appropriate location inside the MySQL container, effectively replacing the standard configuration file.
If you want to base your changes on the standard configuration file, start your MySQL container in the standard way described above, then do:
docker exec -it my-container-name cat /etc/my.cnf > /my/custom/config-file
… where ´/my/custom/config-file´ is the path and name of the new configuration file. Then start a new MySQL container like this:
docker run --name my-new-container-name -v /my/custom/config-file:/etc/my.cnf -e MYSQL_ROOT_PASSWORD=my-secret-pw -d container-registry.oracle.com/mysql/community-server:tag
Oracle 23c New Features for DBA's
Follow Me!!!