MySQL on Docker - Free

Install and configure Docker engine on Amazon Linux 2, enable and start the service, then pull the MySQL image and run it as an isolated container.

Search for and pull the official MySQL image from Docker Hub, then inspect the image to understand layers, tags, and metadata before running it as a container.

Run MySQL as a docker container using the latest image, name the container, set a root password, and run detached on port 3306.

Use docker logs to inspect the MySQL container startup, verify version 8.0.31 and x plugin readiness on ports 33060 and 3306, and understand root password handling.

Access a MySQL 8.0.31 server running in a docker container by using docker exec to open a bash shell on the host and log in as root.

Stop the running MySQL container, remove it (with volumes if needed), then recreate the container with its port exposed to the Docker host for external access.

Learn how a MySQL container exposes its port to the host, mapping container port 3306 to the same host port, and publish it via docker run for external access.

Create a DBA user named Bob in the MySQL container, grant him all DBA privileges, and enable remote login so Bob can connect from a workstation.

Connect to a MySQL container from a remote host by exposing port 3306, log in as Bob, and create an employees database to illustrate containerized databases.

Learn how Docker containers are volatile: if you remove a container, its data disappears unless you attach a persisted volume to the MySQL container.

Bind a local directory as a volume for a Docker container to persist MySQL data by mounting /var/lib/mysql to a host path, preserving employees database and staff table after removal.

Demonstrates persisting MySQL data across container lifecycles by binding a local volume to the container's data directory. Recreates a container that attaches the same volume to access existing data.

Convert a running MySQL instance to a Docker container by binding the existing local volume to the container's /var/lib/mysql and using the same host port.

Stop the MySQL service and run a Docker container with the existing data directory mounted, exposing port 3306. Log in as Bob and access the world database.

Shows how to run MySQL on Docker, pull official images from Docker Hub, create containers, and use persistent volumes to preserve data across containers.