Thaoliy Tian 2021-07-01 22:32 采纳率: 100%
浏览 251
已采纳

django 迁移同步数据库失败(目标计算机积极拒绝)

1、报错信息行
Traceback (most recent call last):
File "D:\Program Files\Python\Python38\lib\site-packages\pymysql\connections.py", line 581, in connect
sock = socket.create_connection(
File "D:\Program Files\Python\Python38\lib\socket.py", line 808, in create_connection
raise err
File "D:\Program Files\Python\Python38\lib\socket.py", line 796, in create_connection
sock.connect(sa)
ConnectionRefusedError: [WinError 10061] 由于目标计算机积极拒绝,无法连接。

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "D:\Program Files\Python\Python38\lib\site-packages\django\db\backends\base\base.py", line 219, in ensure_connection
self.connect()
File "D:\Program Files\Python\Python38\lib\site-packages\django\utils\asyncio.py", line 26, in inner
return func(*args, **kwargs)
File "D:\Program Files\Python\Python38\lib\site-packages\django\db\backends\base\base.py", line 200, in connect
self.connection = self.get_new_connection(conn_params)
File "D:\Program Files\Python\Python38\lib\site-packages\django\utils\asyncio.py", line 26, in inner
return func(*args, **kwargs)
File "D:\Program Files\Python\Python38\lib\site-packages\django\db\backends\mysql\base.py", line 234, in get_new_connection
return Database.connect(**conn_params)
File "D:\Program Files\Python\Python38\lib\site-packages\pymysql_init_.py", line 94, in Connect
return Connection(*args, **kwargs)
File "D:\Program Files\Python\Python38\lib\site-packages\pymysql\connections.py", line 325, in init
self.connect()
File "D:\Program Files\Python\Python38\lib\site-packages\pymysql\connections.py", line 630, in connect
raise exc
pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' ([WinError 10061] 由于目标计算机积极拒绝,无法
连接。)")

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

Traceback (most recent call last):
File "manage.py", line 22, in
main()
File "manage.py", line 18, in main
execute_from_command_line(sys.argv)
File "D:\Program Files\Python\Python38\lib\site-packages\django\core\management_init.py", line 401, in execute_from_command
line
utility.execute()
File "D:\Program Files\Python\Python38\lib\site-packages\django\core\management_init_.py", line 395, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "D:\Program Files\Python\Python38\lib\site-packages\django\core\management\base.py", line 330, in run_from_argv
self.execute(*args, **cmd_options)
File "D:\Program Files\Python\Python38\lib\site-packages\django\core\management\base.py", line 371, in execute
output = self.handle(*args, **options)
File "D:\Program Files\Python\Python38\lib\site-packages\django\core\management\base.py", line 85, in wrapped
res = handle_func(*args, **kwargs)
File "D:\Program Files\Python\Python38\lib\site-packages\django\core\management\commands\makemigrations.py", line 101, in handle

loader.check_consistent_history(connection)

File "D:\Program Files\Python\Python38\lib\site-packages\django\db\migrations\loader.py", line 290, in check_consistent_history
applied = recorder.applied_migrations()
File "D:\Program Files\Python\Python38\lib\site-packages\django\db\migrations\recorder.py", line 77, in applied_migrations
if self.has_table():
File "D:\Program Files\Python\Python38\lib\site-packages\django\db\migrations\recorder.py", line 55, in has_table
with self.connection.cursor() as cursor:
File "D:\Program Files\Python\Python38\lib\site-packages\django\utils\asyncio.py", line 26, in inner
return func(*args, **kwargs)
File "D:\Program Files\Python\Python38\lib\site-packages\django\db\backends\base\base.py", line 259, in cursor
return self._cursor()
File "D:\Program Files\Python\Python38\lib\site-packages\django\db\backends\base\base.py", line 235, in cursor
self.ensure_connection()
File "D:\Program Files\Python\Python38\lib\site-packages\django\utils\asyncio.py", line 26, in inner
return func(*args, **kwargs)
File "D:\Program Files\Python\Python38\lib\site-packages\django\db\backends\base\base.py", line 219, in ensure_connection
self.connect()
File "D:\Program Files\Python\Python38\lib\site-packages\django\db\utils.py", line 90, in exit
raise dj_exc_value.with_traceback(traceback) from exc_value
File "D:\Program Files\Python\Python38\lib\site-packages\django\db\backends\base\base.py", line 219, in ensure_connection
self.connect()
File "D:\Program Files\Python\Python38\lib\site-packages\django\utils\asyncio.py", line 26, in inner
return func(*args, **kwargs)
File "D:\Program Files\Python\Python38\lib\site-packages\django\db\backends\base\base.py", line 200, in connect
self.connection = self.get_new_connection(conn_params)
File "D:\Program Files\Python\Python38\lib\site-packages\django\utils\asyncio.py", line 26, in inner
return func(*args, **kwargs)
File "D:\Program Files\Python\Python38\lib\site-packages\django\db\backends\mysql\base.py", line 234, in get_new_connection
return Database.connect(**conn_params)
File "D:\Program Files\Python\Python38\lib\site-packages\pymysql_init
.py", line 94, in Connect
return Connection(*args, **kwargs)
File "D:\Program Files\Python\Python38\lib\site-packages\pymysql\connections.py", line 325, in init
self.connect()
File "D:\Program Files\Python\Python38\lib\site-packages\pymysql\connections.py", line 630, in connect
raise exc
django.db.utils.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' ([WinError 10061] 由于目标计算机积极拒绝,
无法连接。)")
2、mysql服务已启动
3、setting.py已配置
4、HOST:127.0.0.1 和 localhost 尝试过,依然报错
求各位大哥帮忙解决下,万分感谢

  • 写回答

1条回答 默认 最新

  • CSDN专家-黄老师 2021-07-01 22:54
    关注

    应该是数据库连接不上,你用数据库可视化工具连接mysql试试,安装Navicat Premium 15连接数据库看看

    如果对你有帮助,可以点击我这个回答右上方的【采纳】按钮,给我个采纳吗,谢谢

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥20 删除和修改功能无法调用
  • ¥15 kafka topic 所有分副本数修改
  • ¥15 小程序中fit格式等运动数据文件怎样实现可视化?(包含心率信息))
  • ¥15 如何利用mmdetection3d中的get_flops.py文件计算fcos3d方法的flops?
  • ¥40 串口调试助手打开串口后,keil5的代码就停止了
  • ¥15 电脑最近经常蓝屏,求大家看看哪的问题
  • ¥60 高价有偿求java辅导。工程量较大,价格你定,联系确定辅导后将采纳你的答案。希望能给出完整详细代码,并能解释回答我关于代码的疑问疑问,代码要求如下,联系我会发文档
  • ¥50 C++五子棋AI程序编写
  • ¥30 求安卓设备利用一个typeC接口,同时实现向pc一边投屏一边上传数据的解决方案。
  • ¥15 SQL Server analysis services 服务安装失败