celiasaidani/mysql repository overview

⁠OS

• This image uses [Debian][1] 8 (jessie).

⁠Content

• Mysql ``

⁠Run

⁠Create Dockerfile

• Build the image: docker build -t mysql .
• Run an instance test of the image: docker run -d --name="mysql-Test" -e MYSQL_PASSWORD=password -p 3307:3306 mysql
  
• insert table test in database:
  mysql -u <USER> -p<YOURPASSWORD> 127.0.0.1 -port=3306<./setup/1-SCHEMA.sql
mysql -u <USER> -p<YOURPASSWORD> 127.0.0.1 -port=3306<./setup/2-PRIVILEGES.sql
mysql -u <USER> -p<YOURPASSWORD> 127.0.0.1 -port=3306<./setup/3-ENTRIES.sql
  
• Run an instance Prod of the image:
  docker run -d --name="mysql-Prod" -e MYSQL_PASSWORD=password -p 3307:3306 mysql
• insert table test in database:
  mysql -u <USER> -p<YOURPASSWORD> 127.0.0.1 -port=3306<./setup/1-SCHEMA.sql
mysql -u <USER> -p<YOURPASSWORD> 127.0.0.1 -port=3306<./setup/2-PRIVILEGES.sql
  

⁠Docker network for testing with maven

docker network create test-network
docker network connect test-network mysql-Test

⁠Docker network for testing with tomcat

docker network create prod-network
docker network connect prod-network mysql-Prod