Operation Error while connecting flask app to mysql

Bilal05476 commented 11 months ago

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

Screenshot from 2023-10-07 17-08-11

Both containers in same network but above error persist

sitchatt commented 11 months ago

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

Sudarshankevat commented 6 months ago

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

pratiksha-design261 commented 1 month ago

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:

LondheShubham153 / two-tier-flask-app