django mysql内存泄漏_mysql - Django无法连接MySQL

本文链接：https://blog.csdn.net/weixin_32019329/article/details/114166121

在尝试使用Python Django框架执行`makemigrations`命令时遇到MySQL连接问题，错误代码2003表示无法连接到本地MySQL服务器（127.0.0.1）。尽管可以使用命令行正常连接到MySQL，但在Django中却出现ConnectionRefusedError。在settings.py中尝试使用'127.0.0.1'和'localhost'作为数据库主机均无效，且系统未监听3306端口。问题可能涉及未配置的MySQL服务或防火墙设置，尤其是在CentOS7环境中。

摘要由CSDN通过智能技术生成

执行命令python3 manage.py makemigrations user

Traceback (most recent call last):

File "/usr/local/python3/lib/python3.7/site-packages/pymysql/connections.py", line 582, in connect

**kwargs)

File "/usr/local/python3/lib/python3.7/socket.py", line 727, in create_connection

raise err

File "/usr/local/python3/lib/python3.7/socket.py", line 716, in create_connection

sock.connect(sa)

ConnectionRefusedError: [Errno 111] Connection refused

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "/usr/local/python3/lib/python3.7/site-packages/django/db/backends/base/base.py", line 217, in ensure_connection

self.connect()

File "/usr/local/python3/lib/python3.7/site-packages/django/db/backends/base/base.py", line 195, in connect

self.connection = self.get_new_connection(conn_params)

File "/usr/local/python3/lib/python3.7/site-packages/django/db/backends/mysql/base.py", line 227, in get_new_connection

return Database.connect(**conn_params)

File "/usr/local/python3/lib/python3.7/site-packages/pymysql/__init__.py", line 94, in Connect

return Connection(*args, **kwargs)

File "/usr/local/python3/lib/python3.7/site-packages/pymysql/connections.py", line 327, in __init__

self.connect()

File "/usr/local/python3/lib/python3.7/site-packages/pymysql/connections.py", line 629, in connect

raise exc

pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on '127.0.0.1' ([Errno 111] Connection refused)")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):

File "manage.py", line 21, in

main()

File "manage.py", line 17, in main

execute_from_command_line(sys.argv)

File "/usr/local/python3/lib/python3.7/site-packages/django/core/management/__init__.py", line 381, in execute_from_command_line

utility.execute()

.....

self.connection = self.get_new_connection(conn_params)

File "/usr/local/python3/lib/python3.7/site-packages/django/db/backends/mysql/base.py", line 227, in get_new_connection

return Database.connect(**conn_params)

File "/usr/local/python3/lib/python3.7/site-packages/pymysql/__init__.py", line 94, in Connect

return Connection(*args, **kwargs)

File "/usr/local/python3/lib/python3.7/site-packages/pymysql/connections.py", line 327, in __init__

self.connect()

File "/usr/local/python3/lib/python3.7/site-packages/pymysql/connections.py", line 629, in connect

raise exc

django.db.utils.OperationalError: (2003, "Can't connect to MySQL server on '127.0.0.1' ([Errno 111] Connection refused)")

但是，我可以使用mysql -u root -p连接到mysql。我已经在settings.py中尝试了数据库的主机'127.0.0.1'或'本地主机'。他们俩都没有工作。未配置MySQL吗？此外，我发现机器没有监视端口3306。

如何解决？(系统为centOS7)

django mysql内存泄漏_mysql - Django无法连接MySQL - 堆栈内存溢出