在本地调试 docker-compose 调试 mysql+nginx+flask 程序,报错(2003, "Can't connect to MySQL server on '127.0.0.1' ([Errno 111] Connection refused)")。
线索如下:
Flask app 运行地址: 0.0.0.0:5000
已将 mysql.cnf 中的bind-address改为0.0.0.0,并在容器里面确认过更改成功
使用 MySQLWorkbench 可以成功连接到 localhost 数据库
SQLALCHEMY_DATABASE_URI = 'mysql+pymysql://root:[email protected]:3306/my_database?charset=utf8'
期待回复,非常感谢!
完整的错误日志:
webapp_1 | The above exception was the direct cause of the following exception:
webapp_1 |
webapp_1 | Traceback (most recent call last):
webapp_1 | File "/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py", line 135, in handle
webapp_1 | self.handle_request(listener, req, client, addr)
webapp_1 | File "/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py", line 176, in handle_request
webapp_1 | respiter = self.wsgi(environ, resp.start_response)
webapp_1 | File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1997, in __call__
webapp_1 | return self.wsgi_app(environ, start_response)
webapp_1 | File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1985, in wsgi_app
webapp_1 | response = self.handle_exception(e)
webapp_1 | File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1540, in handle_exception
webapp_1 | reraise(exc_type, exc_value, tb)
webapp_1 | File "/usr/local/lib/python3.6/site-packages/flask/_compat.py", line 33, in reraise
webapp_1 | raise value
webapp_1 | File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1982, in wsgi_app
webapp