Skip to content

Instantly share code, notes, and snippets.

@diversen
Created October 24, 2021 08:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save diversen/1cc517990ffd9c3468ffe5bfb56f97b5 to your computer and use it in GitHub Desktop.
Save diversen/1cc517990ffd9c3468ffe5bfb56f97b5 to your computer and use it in GitHub Desktop.
Docker and MySQL - small guide

Docker MySQL

Install (run) a MySQL image that will work:

docker run -p 3306:3306 --name mysql-server -e MYSQL_ROOT_PASSWORD=password -d mysql:5.7

Connect using bash and create a database:

docker exec -it mysql-server bash
mysql -uroot -ppassword
create database database_name;
exit; # exit from mysql-server 
exit; # exit from container

Load some SQL:

docker exec -i mysql-server mysql -uroot -ppassword database_name  < ./sql/mysql.sql 

List conainers

docker container ls

Stop container (mysql-server):

docker stop mysql-server

Start container (mysql-server) again:

docker start mysql-server

Remove container (you will need run 'run' command again):

docker rm mysql-server
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment