Operation Error while connecting flask app to mysql

[Bilal05476]

OperationalError
MySQLdb.OperationalError: (2002, "Can't connect to local server through socket '/run/mysqld/mysqld.sock' (2)")

Both containers in same network but above error persist

[sitchatt]

Hi, can you tell me more about your other configuration too? What is the MySQL port you selected?

[Sudarshankevat]

Hi, can you tell me more about your other configuration too? What is the MySQL port you selected?
port no : 3306

[pratiksha-design261]

Use the below code for docker-compose.yml it will fix above error :
version: '3.9'
services:

flask-app:
container_name: 'flask-python-application'
build:
context: .
ports:
- '5000:5000'
environment:
MYSQL_HOST: 'mysql-db'
MYSQL_USER: 'root'
MYSQL_PASSWORD: 'root'
MYSQL_DB: 'devops'
depends_on:
mysql-db:
condition: service_healthy

mysql-db:
container_name: 'mysql-db'
image: 'mysql:5.7'
ports:
- "3306:3306"
environment:
MYSQL_ROOT_PASSWORD: 'root'
MYSQL_DATABASE: 'devops'
volumes:
- type: volume
source: mysql-volume-data
target: /var/lib/mysql
healthcheck:
test: ["CMD", "mysqladmin", "ping", "-h", "localhost"]
interval: 10s
timeout: 5s
retries: 3

volumes:
mysql-volume-data:

[Iam-Tej23]

please use mysql ip in two-tier-app-deployment.yaml file so that it work fine.