connecting to a docker-compose mysql container denies access but docker running same image does not

by

Environment variables in docker-compose.yml file should not have quotes when using array definition:

db:
  image: mysql:5.7
  ports:
    - "3306:3306"
  environment:
    - MYSQL_ROOT_PASSWORD=secret
    - MYSQL_USER=django
    - MYSQL_PASSWORD=secret
    - MYSQL_DATABASE=myAppDB

If you use them in your docker-compose.yml file:

db:
  image: mysql:5.7
  ports:
    - "3306:3306"
  environment:
    - MYSQL_ROOT_PASSWORD="secret"
    - MYSQL_USER="django"
    - MYSQL_PASSWORD="secret"
    - MYSQL_DATABASE="myAppDB"

and run:

$ docker-compose up -d

and enter running container:

$ docker-compose exec db /bin/bash

you will see the output:

root@979813643b0c:/# echo $MYSQL_ROOT_PASSWORD                                                                                                                                              
"secret"

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. Connect to Docker MySQL container from localhost?
  5. Node.js connect to MySQL Docker container ECONNREFUSED
  6. How to connect locally hosted MySQL database with the docker container
  7. django cannot connect mysql in docker-compose
  8. Setting up MySQL and importing dump within Dockerfile
  9. How can I initialize a MySQL database with schema in a Docker container?
  10. Connect to mysql in a docker container from the host
  11. How to connect mysql workbench to running mysql inside docker?
  12. How do I know when my docker mysql container is up and mysql is ready for taking queries?
  13. Docker (Apple Silicon/M1 Preview) MySQL “no matching manifest for linux/arm64/v8 in the manifest list entries”
  14. Commit data in a mysql container
  15. Access to mysql container from other container
  16. How to initialize mysql container when created on Kubernetes?
  17. MySQL scripts in docker-entrypoint-initdb are not executed
  18. Reorder / reset auto increment primary key
  19. Required to join 2 tables with their FKs in a 3rd table
  20. Setting the MySQL root user password on OS X
  21. Mysql::Error: Specified key was too long; max key length is 1000 bytes
  22. How can I get around MySQL Errcode 13 with SELECT INTO OUTFILE?
  23. How to auto generate migrations with Sequelize CLI from Sequelize models?
  24. How can I manipulate MySQL fulltext search relevance to make one field more ‘valuable’ than another?
  25. Creating functions in phpMyAdmin – Error: access denied you need the super privilege for this operation
  26. How to connect to MySQL from the command line
  27. What are the differences between the BLOB and TEXT datatypes in MySQL?
  28. count top 10 most occuring values in a column in mysql
  29. What is the purpose of the file “docker.sock”?
  30. #1214 – The used table type doesn’t support FULLTEXT indexes

Leave a Comment