Connecting to MySql server running in a Docker Container

Question

I have a little problem, I can't seem to connect to mysql server community edition running inside a docker container.

I can easily connect to mysql server using the cli by using:

docker exec -it mysqlserver mysql -uroot -p

But if I try to connect with any other database connector, like DataGrip or MySql Workbench, I get an access denied.

But I changed nothing in the configuration files. I set ip as localhost, using the default 3306 port that the container exposed. username I keep as root and the password is exactly the same but it still keeps failing.

Am I missing something, not understanding anything properly?

Some help would be greatly appreciated!

Extra info: I am using MacOS, running the container with Docker for Mac and I am using as of this moment the latest MySql database version.

I am not using a docker-conpose.yml or should i be using one? I am new to docker, trying to understand it. — Tim Smeets
– Tim Smeets, Commented Jan 11, 2018 at 21:06
I asked because you give absolutely no info on how you run it and what your settings are. — Kevin Kopf
– Kevin Kopf, Commented Jan 12, 2018 at 12:09

Kilian · Accepted Answer · 2018-01-11 19:48:36Z

1

your container doesn't contain other connectors, try to publish port when you run your container with docker run --name mysql -p 127.0.0.1:3306:3306 .... to link port. And you can connect you to the container with your local cli. Try this doc

edited Jan 11, 2018 at 19:48

answered Jan 11, 2018 at 19:47

Kilian

1,79115 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Tim Smeets Over a year ago

I tried it but I keep getting the samen errors, only way i am able to connect to mysql server running in the contrainer is trough docker itself using: docker exec -it mysql mysql -uroot -p using an 'external' method keeps leading to an acces denied, I really feel like I missing a key piece of information that I have to know about how the containers work.

Kilian Over a year ago

Worked for me, with docker run -p 127.0.0.1:3306:3306 --name test -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql:latest Check logs and wait for mysql starts completly, you can connect inside container to verify. And after from your host mysql -h 127.0.0.1 -u root -p

Grant Palin · Accepted Answer · 2018-01-26 18:06:56Z

1

Below is the docker-compose.yml that I used to start up a MariaDB instance for testing some queries. MariaDB is API-compatible with MySQL, so no difference.

version: "2"

services:
  db:
    image: bitnami/mariadb:latest
    volumes:
      - ./mariadb/data:/bitnami
    ports:
      - "9001:3306"
    environment:
      MARIADB_ROOT_PASSWORD: ChangeMeIfYouWant
  phpmyadmin:
    image: phpmyadmin/phpmyadmin:latest
    ports:
      - "9010:80"
    links:
      - db:db

The image is downloaded and the container created and started via docker-compose up. Afterwards, I can easily connect to it using JetBrains DataGrip.

host: localhost
port: 9001
user: root
password: ChangeMeIfYouWant

answered Jan 26, 2018 at 18:06

Grant Palin

4,5783 gold badges39 silver badges58 bronze badges

Collectives™ on Stack Overflow

Connecting to MySql server running in a Docker Container

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related