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连接数据库看看

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

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

报告相同问题?

悬赏问题

  • ¥15 关于#matlab#的问题:在模糊控制器中选出线路信息,在simulink中根据线路信息生成速度时间目标曲线(初速度为20m/s,15秒后减为0的速度时间图像)我想问线路信息是什么
  • ¥15 banner广告展示设置多少时间不怎么会消耗用户价值
  • ¥16 mybatis的代理对象无法通过@Autowired装填
  • ¥15 可见光定位matlab仿真
  • ¥15 arduino 四自由度机械臂
  • ¥15 wordpress 产品图片 GIF 没法显示
  • ¥15 求三国群英传pl国战时间的修改方法
  • ¥15 matlab代码代写,需写出详细代码,代价私
  • ¥15 ROS系统搭建请教(跨境电商用途)
  • ¥15 AIC3204的示例代码有吗,想用AIC3204测量血氧,找不到相关的代码。