Can't reach dockerized database outside docker

Question

services:
  db:
    image: mariadb
    ports:
      - 3306:3306
    command: --transaction-isolation=READ-COMMITTED --binlog-format=ROW
    restart: always
    volumes:
      - db:/var/lib/mysql
    environment:
      - MYSQL_ROOT_PASSWORD=pw
      - MYSQL_PASSWORD=pw
      - MYSQL_DATABASE=db
      - MYSQL_USER=user

I used this to create a database, ran docker-compose up, then tried to access the database with:

sudo mysql -u user -h 127.0.0.1:3306 -p

But I get the following error:

ERROR 2005 (HY000): Unknown MySQL server host '127.0.0.1:3306' (-2)

It seems like the port 3306 isn't actually exposed and I don't understand why.

rkosegi · Accepted Answer · 2019-12-28 12:50:47Z

1

Your command syntax is invalid. Should be

mysql -u user -h 127.0.0.1 -P 3306 -p

When using default port (3306) you can omit it completely.

mysql -u user -h 127.0.0.1 -p

answered Dec 28, 2019 at 12:50

rkosegi

14.8k5 gold badges57 silver badges90 bronze badges

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

Comments

Adiii · Accepted Answer · 2019-12-28 12:51:05Z

1

Remove port from the DB Host, it should only contain URL

mysql -u user -h 127.0.0.1 -p

answered Dec 28, 2019 at 12:51

Adiii

61k10 gold badges178 silver badges172 bronze badges

Collectives™ on Stack Overflow

Can't reach dockerized database outside docker

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related