I am developing a docker-compose file for my setup. Main issue I have is connecting from host to a working docker-container with mysql.
As my hostname I’m using the containername: “docker_mysql”, username & password as specified in the yaml file.
However, It always returns “connection failed”. I have granted the correct privileges to the root user, though still the same. Have also tried to connect via ip, and/or localhost - still same failing result.
Soon pulling my hair. After much search on google, still no solution.
Anyone can see what i’m doing wrong?
version: "3.9"
services:
mysql:
image: mysql:5.7
build: ./Docker/mysql
container_name: docker_mysql
restart: always
ports:
- "3308:3306"
environment:
MYSQL_DATABASE: "xx"
MYSQL_USER: "xx"
MYSQL_PASSWORD: "xx"
MYSQL_ROOT_PASSWORD: "xx"
networks:
- app_network
networks:
app_network:
driver: "bridge"
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Hi there,
The Docker container name can be used as a hostname within the Docker network itself.
As you are accessing your MySQL container from your laptop directly, you should use 127.0.0.1 instead along with the port that you’ve exposed: 3308.
Let me know how it goes!
Best,
Bobby
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Start building today
From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.
