Step-by-Step Guide to Installing MySQL Using Docker

First, pull the MySQL 5.7 image from Docker Hub: sudo docker pull mysql:5.7 The command downloads the image and shows progress details, confirming the image is ready for use.

Verify the downloaded image with: sudo docker images Next, create and start a MySQL container, mapping host directories for logs, data, and configuration, exposing port 3306, and setting the root password:

sudo docker run -p 3306:3306 --name mysql \
  -v /mydata/mysql/log:/var/log/mysql \
  -v /mydata/mysql/data:/var/lib/mysql \
  -v /mydata/mysql/conf:/etc/mysql \
  -e MYSQL_ROOT_PASSWORD=root \
  -d mysql:5.7

After the container starts, you can list running containers to confirm the MySQL instance is active.

Connect to the MySQL server using MySQL Workbench or any client, then verify the databases are accessible.

To enter the container’s shell for further inspection or management, run: sudo docker exec -it mysql /bin/bash Finally, on the host machine, view the mapped directories to see the persisted log, data, and configuration files:

cd /mydata/mysql
ls

This series of commands provides a complete setup for running MySQL in Docker with persistent storage and easy access for development or testing purposes.