opavlova/db-mysql repository overview

⁠MySQL

https://www.mysql.com/⁠

⁠Image tags

 opavlova/db-mysql:5.5         MySQL version:  5.5.51
 opavlova/db-mysql:5.6         MySQL version:  5.6.32
 opavlova/db-mysql:5.7         MySQL version:  5.7.14

OS: Linux (x86_64)

⁠Usage

⁠How to connect to DB in IntelliJ IDEA 2020.3

1. Install docker https://docs.docker.com/engine/installation/⁠ https://docs.docker.com/engine/userguide/⁠

2. Add Docker support https://www.jetbrains.com/help/idea/docker.html⁠

3. Create a Dockerfile with the following content there:

FROM  opavlova/db-mysql:5.5

1. Create and run a New Run Configuration

   click on the "Run on Docker' gutter (near "FROM" in the Editor)  -> choose "New Run Configuration"
   enter "-p 13306:3306"   into the  "Run options" field 
   Run  ( results are in the Services View )
   

   Copy

2. Create connection to the database in the Database View:

   go to the Database View, add new MySQL Data Source
   add URL:  jdbc:mysql://localhost:13306/DOCKERDB
   add password=root, user=root
   Connect.
   

   Copy

Dockerfile for opavlova/db-mysql:5.5 image: https://github.com/IdeaUJetBrains/DockerFiles/tree/master/docker-dir/db/mysql⁠