Connect to Docker MySQL container from localhost?

by

Using docker-compose up

Since you published port 3306 on your docker host, from that host itself you would connect to 127.0.0.1:3306.

Using docker-compose run

In that case the port mapping section of the docker-compose.yml file is ignored. To have the port mapping section considered, you have to add the --service-ports option: 

docker-compose run --service-ports db

Additional note

Beware that by default, the mysql client tries to connect using a unix socket when you tell it to connect to localhost. So do use 127.0.0.1 and not localhost:

 $ mysql -h 127.0.0.1 -P 3306 -u root

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.26 MySQL Community Server (GPL)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql>

$ mysql -h localhost -P 3306 -u root

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)

More Related Contents:

  1. Docker-compose check if mysql connection is ready
  2. MYSQL_ROOT_PASSWORD is set but getting “Access denied for user ‘root’@’localhost’ (using password: YES)” in docker container
  3. Communications link failure , Spring Boot + MySql +Docker + Hibernate
  4. Node.js connect to MySQL Docker container ECONNREFUSED
  5. How to connect locally hosted MySQL database with the docker container
  6. connecting to a docker-compose mysql container denies access but docker running same image does not
  7. django cannot connect mysql in docker-compose
  8. Location of my.cnf file on macOS
  9. brew install mysql on macOS
  10. Setting up MySQL and importing dump within Dockerfile
  11. How can I initialize a MySQL database with schema in a Docker container?
  12. Setting the MySQL root user password on OS X
  13. MySQL user DB does not have password columns – Installing MySQL on OSX
  14. Connect to mysql in a docker container from the host
  15. How do you uninstall MySQL from Mac OS X?
  16. How to connect mysql workbench to running mysql inside docker?
  17. Restoring deleted ‘root’ user and password for MySQL
  18. Docker (Apple Silicon/M1 Preview) MySQL “no matching manifest for linux/arm64/v8 in the manifest list entries”
  19. Ruby on Rails 3 Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ on OSX
  20. Error: Tablespace for table xxx exists. Please DISCARD the tablespace before IMPORT
  21. Commit data in a mysql container
  22. rails + MySQL on OSX: Library not loaded: libmysqlclient.18.dylib
  23. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ [duplicate]
  24. Access to mysql container from other container
  25. PID error on mysql.server start?
  26. How to start MySQL server from command line on Mac OS Lion?
  27. How to auto-load MySQL on startup on OS X Yosemite / El Capitan
  28. How to initialize mysql container when created on Kubernetes?
  29. OSX ld: library not found for -lssl
  30. MySQL scripts in docker-entrypoint-initdb are not executed

Leave a Comment