Connect to mysql in a docker container from the host

by

If your Docker MySQL host is running correctly you can connect to it from local machine, but you should specify host, port and protocol like this:

mysql -h localhost -P 3306 --protocol=tcp -u root

Change 3306 to port number you have forwarded from Docker container (in your case it will be 12345).

Because you are running MySQL inside Docker container, socket is not available and you need to connect through TCP. Setting “–protocol” in the mysql command will change that.

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. Setting up MySQL and importing dump within Dockerfile
  4. How can I initialize a MySQL database with schema in a Docker container?
  5. How to connect mysql workbench to running mysql inside docker?
  6. How do I know when my docker mysql container is up and mysql is ready for taking queries?
  7. Docker (Apple Silicon/M1 Preview) MySQL “no matching manifest for linux/arm64/v8 in the manifest list entries”
  8. Commit data in a mysql container
  9. Communications link failure , Spring Boot + MySql +Docker + Hibernate
  10. Connect to Docker MySQL container from localhost?
  11. Node.js connect to MySQL Docker container ECONNREFUSED
  12. How to connect locally hosted MySQL database with the docker container
  13. Access to mysql container from other container
  14. connecting to a docker-compose mysql container denies access but docker running same image does not
  15. How to initialize mysql container when created on Kubernetes?
  16. django cannot connect mysql in docker-compose
  17. MySQL scripts in docker-entrypoint-initdb are not executed
  18. Get records with max value for each group of grouped SQL results
  19. How to store multiple options in a single table?
  20. Get the new record primary key ID from MySQL insert query?
  21. TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT maximum storage sizes
  22. Add 2 hours to current time in MySQL?
  23. Can MySQL replace multiple characters?
  24. My MySQL trigger doesn’t work, simple syntax, not complicated
  25. How can VBA connect to MySQL database in Excel?
  26. Select a column with a keyword name
  27. Sum results of a few queries and then find top 5 in SQL
  28. ERROR 1356 (HY000): View ‘mysql.user’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
  29. How do you force mysql LIKE to be case sensitive? [duplicate]
  30. MySQL Alter table causes Error: Invalid use of NULL value

Leave a Comment