flask mysql docker,使用docker-compose从Flask Application连接到MySQL

I have an application using Flask and MySQL. The application does not connect to MySQL container from the Flask Application but it can be accessed using Sequel Pro with the same credentials.

Docker Compose File

version: '2'

services:

web:

build: flask-app

ports:

- "5000:5000"

volumes:

- .:/code

mysql:

build: mysql-server

environment:

MYSQL_DATABASE: test

MYSQL_ROOT_PASSWORD: root

MYSQL_ROOT_HOST: 0.0.0.0

MYSQL_USER: testing

MYSQL_PASSWORD: testing

ports:

- "3306:3306"

Docker file for MySQL

The docker file for MySQL will add schema from test.dump file.

FROM mysql/mysql-server

ADD test.sql /docker-entrypoint-initdb.d

Docker file for Flask

FROM python:latest

COPY . /app

WORKDIR /app

RUN pip install -r requirements.txt

ENTRYPOINT ["python"]

CMD ["app.py"]

Starting point app.py

from flask import Flask, request, jsonify, Response

import json

import mysql.connector

from flask_cors import CORS, cross_origin

app = Flask(__name__)

def getMysqlConnection():

return mysql.connector.connect(user='testing', host='0.0.0.0', port='3306', password='testing', database='test')

@app.route("/")

def hello():

return "Flask inside Docker!!"

@app.route('/api/getMonths', methods=['GET'])

@cross_origin() # allow all origins all methods.

def get_months():

db = getMysqlConnection()

print(db)

try:

sqlstr = "SELECT * from retail_table"

print(sqlstr)

cur = db.cursor()

cur.execute(sqlstr)

output_json = cur.fetchall()

except Exception as e:

print("Error in SQL:\n", e)

finally:

db.close()

return jsonify(results=output_json)

if __name__ == "__main__":

app.run(debug=True,host='0.0.0.0')

When I do a GET request on http://localhost:5000/ using REST Client I get a valid response.

A GET request on http://localhost:5000/api/getMonths gives error message:

mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on '0.0.0.0:3306' (111 Connection refused)

When the same credentials were used on Sequel Pro, I was able to access the database.

Please advice me on how to connect the MySQL container from the Flask Application. This is my first time suing Docker and do forgive me if this is a silly mistake from my part.

解决方案

Change this

return mysql.connector.connect(user='testing', host='0.0.0.0', port='3306', password='testing', database='test')

to

return mysql.connector.connect(user='testing', host='mysql', port='3306', password='testing', database='test')

Your code is running inside the container and not on your host. So you need to provide it a address where it can reach within container network. For docker-compose each service is reachable using its name. So in your it is mysql as that is name you have used for the service