MySql with Docker

Running a MySQL database in a Docker container is straightforward. Here are the steps:

Pull the Official MySQL Image:

The official MySQL image is available on Docker Hub. You can choose the version you want (e.g., MySQL 8.0): docker pull mysql:8.0

Create a Docker Volume (Optional):

To persist your database data, create a Docker volume or bind mount. Otherwise, data will be lost when the container restarts.

Example using a volume: docker volume create mysql-data

Run the MySQL Container:

Use the following command to start a MySQL container: docker run --name my-mysql -e MYSQL_ROOT_PASSWORD=secret -v mysql-data:/var/lib/mysql -d mysql:8.0

Replace secret with your desired root password.

The MySQL first-run routine will take a few seconds to complete.

Check if the database is up by running: docker logs my-mysql

Look for a line that says “ready for connections.”

Access MySQL Shell:

To interact with MySQL, attach to the container and run the mysql command: docker exec -it my-mysql mysql -p

Enter the root password when prompted.

To import an SQL file from your filesystem: docker exec -it my-mysql mysql -psecret database_name < path-to-file.sql

Access MySQL from Host:

If you want to access MySQL from your host machine, set up a port binding:

Add the following to your docker-compose.yml file (if using Docker Compose):

services:

mysql:

ports:

- 33060:3306

If not using Docker Compose, pass -p 33060:3306 to docker run.

That’s it! You now have a MySQL database running in a Docker container.