Django迁移文件计算机无法访问虚拟机上的mysql[django.db.utils.OperationalError: (2003, "Can't connect to MySQL server on '127.0.0.1' ([WinError 10061] 由于目标计算机积极拒绝,无法连接。)")]
(env) D:\python_learn\meiduo_project\meiduo_mall>python manage.py makemigrations Traceback (most recent call last): File "manage.py", line 22, in <module> execute_from_command_line(sys.argv) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\core\management\__init__.py", line 401, in execute_from_command_line utility.execute() File "D:\python_learn\meiduo_project\env\lib\site-packages\django\core\management\__init__.py", line 377, in execute django.setup() File "D:\python_learn\meiduo_project\env\lib\site-packages\django\__init__.py", line 24, in setup apps.populate(settings.INSTALLED_APPS) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\apps\registry.py", line 114, in populate app_config.import_models() File "D:\python_learn\meiduo_project\env\lib\site-packages\django\apps\config.py", line 211, in import_models self.models_module = import_module(models_module_name) File "D:\Python\Python38\lib\importlib\__init__.py", line 127, in import_module return _bootstrap._gcd_import(name[level:], package, level) File "<frozen importlib._bootstrap>", line 1014, in _gcd_import File "<frozen importlib._bootstrap>", line 991, in _find_and_load File "<frozen importlib._bootstrap>", line 975, in _find_and_load_unlocked File "<frozen importlib._bootstrap>", line 671, in _load_unlocked File "<frozen importlib._bootstrap_external>", line 783, in exec_module File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed File "D:\python_learn\meiduo_project\env\lib\site-packages\django\contrib\auth\models.py", line 2, in <module> from django.contrib.auth.base_user import AbstractBaseUser, BaseUserManager File "D:\python_learn\meiduo_project\env\lib\site-packages\django\contrib\auth\base_user.py", line 47, in <module> class AbstractBaseUser(models.Model): File "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\models\base.py", line 121, in __new__ new_class.add_to_class('_meta', Options(meta, app_label)) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\models\base.py", line 325, in add_to_class value.contribute_to_class(cls, name) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\models\options.py", line 208, in contribute_to_class self.db_table = truncate_name(self.db_table, connection.ops.max_name_length()) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\__init__.py", line 28, in __getattr__ return getattr(connections[DEFAULT_DB_ALIAS], item) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\utils.py", line 207, in __getitem__ backend = load_backend(db['ENGINE']) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\utils.py", line 111, in load_backend return import_module('%s.base' % backend_name) File "D:\Python\Python38\lib\importlib\__init__.py", line 127, in import_module return _bootstrap._gcd_import(name[level:], package, level) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\backends\mysql\base.py", line 37, in <module> raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3. (env) D:\python_learn\meiduo_project\meiduo_mall>python manage.py makemigrations Traceback (most recent call last): File "D:\python_learn\meiduo_project\env\lib\site-packages\pymysql\connections.py", line 581, in connect sock = socket.create_connection( File "D:\Python\Python38\lib\socket.py", line 808, in create_connection raise err File "D:\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:\python_learn\meiduo_project\env\lib\site-packages\django\db\backends\base\base.py", line 220, in ensure_connection self.connect() File "D:\python_learn\meiduo_project\env\lib\site-packages\django\utils\asyncio.py", line 26, in inner return func(*args, **kwargs) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\backends\base\base.py", line 197, in connect self.connection = self.get_new_connection(conn_params) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\utils\asyncio.py", line 26, in inner return func(*args, **kwargs) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\backends\mysql\base.py", line 233, in get_new_connection return Database.connect(**conn_params) File "D:\python_learn\meiduo_project\env\lib\site-packages\pymysql\__init__.py", line 94, in Connect return Connection(*args, **kwargs) File "D:\python_learn\meiduo_project\env\lib\site-packages\pymysql\connections.py", line 325, in __init__ self.connect() File "D:\python_learn\meiduo_project\env\lib\site-packages\pymysql\connections.py", line 630, in connect raise exc pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on '127.0.0.1' ([WinError 10061] 由于目标计算机积极拒绝,无法连接。)") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "manage.py", line 22, in <module> execute_from_command_line(sys.argv) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\core\management\__init__.py", line 401, in execute_from_command_line utility.execute() File "D:\python_learn\meiduo_project\env\lib\site-packages\django\core\management\__init__.py", line 395, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\core\management\base.py", line 328, in run_from_argv self.execute(*args, **cmd_options) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\core\management\base.py", line 366, in execute self.check() File "D:\python_learn\meiduo_project\env\lib\site-packages\django\core\management\base.py", line 392, in check all_issues = self._run_checks( File "D:\python_learn\meiduo_project\env\lib\site-packages\django\core\management\base.py", line 382, in _run_checks return checks.run_checks(**kwargs) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\core\checks\registry.py", line 72, in run_checks new_errors = check(app_configs=app_configs) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\core\checks\model_checks.py", line 34, in check_all_models errors.extend(model.check(**kwargs)) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\models\base.py", line 1275, in check *cls._check_constraints(), File "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\models\base.py", line 1843, in _check_constraints connection.features.supports_table_check_constraints or File "D:\python_learn\meiduo_project\env\lib\site-packages\django\utils\functional.py", line 48, in __get__ res = instance.__dict__[self.name] = self.func(instance) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\backends\mysql\features.py", line 93, in supports_column_check_constraints if self.connection.mysql_is_mariadb: File "D:\python_learn\meiduo_project\env\lib\site-packages\django\utils\functional.py", line 48, in __get__ res = instance.__dict__[self.name] = self.func(instance) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\backends\mysql\base.py", line 363, in mysql_is_mariadb return 'mariadb' in self.mysql_server_info.lower() File "D:\python_learn\meiduo_project\env\lib\site-packages\django\utils\functional.py", line 48, in __get__ res = instance.__dict__[self.name] = self.func(instance) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\backends\mysql\base.py", line 350, in mysql_server_info with self.temporary_connection() as cursor: File "D:\Python\Python38\lib\contextlib.py", line 113, in __enter__ return next(self.gen) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\backends\base\base.py", line 604, in temporary_connection with self.cursor() as cursor: File "D:\python_learn\meiduo_project\env\lib\site-packages\django\utils\asyncio.py", line 26, in inner return func(*args, **kwargs) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\backends\base\base.py", line 260, in cursor return self._cursor() File "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\backends\base\base.py", line 236, in _cursor self.ensure_connection() File "D:\python_learn\meiduo_project\env\lib\site-packages\django\utils\asyncio.py", line 26, in inner return func(*args, **kwargs) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\backends\base\base.py", line 220, in ensure_connection self.connect() File "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\utils.py", line 90, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\backends\base\base.py", line 220, in ensure_connection self.connect() File "D:\python_learn\meiduo_project\env\lib\site-packages\django\utils\asyncio.py", line 26, in inner return func(*args, **kwargs) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\backends\base\base.py", line 197, in connect self.connection = self.get_new_connection(conn_params) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\utils\asyncio.py", line 26, in inner return func(*args, **kwargs) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\backends\mysql\base.py", line 233, in get_new_connection return Database.connect(**conn_params) File "D:\python_learn\meiduo_project\env\lib\site-packages\pymysql\__init__.py", line 94, in Connect return Connection(*args, **kwargs) File "D:\python_learn\meiduo_project\env\lib\site-packages\pymysql\connections.py", line 325, in __init__ self.connect() File "D:\python_learn\meiduo_project\env\lib\site-packages\pymysql\connections.py", line 630, in connect raise exc django.db.utils.OperationalError: (2003, "Can't connect to MySQL server on '127.0.0.1' ([WinError 10061] 由于目标计算机积极拒绝,无法连接。)")
使用服务器ip,不要使用127.0.0.1
壬戌之秋,七月既望,苏子与客泛舟游于赤壁之下。清风徐来,水波不兴。举酒属客,诵明月之诗,歌窈窕之章。少焉,月出于东山之上,徘徊于斗牛之间。白露横江,水光接天。纵一苇之所如,凌万顷之茫然。浩浩乎如冯虚御风,而不知其所止;飘飘乎如遗世独立,羽化而登仙。
于是饮酒乐甚,扣舷而歌之。歌曰:“桂棹兮兰桨,击空明兮溯流光。渺渺兮予怀,望美人兮天一方。”客有吹洞箫者,倚歌而和之。其声呜呜然,如怨如慕,如泣如诉,余音袅袅,不绝如缕。舞幽壑之潜蛟,泣孤舟之嫠妇。
苏子愀然,正襟危坐而问客曰:“何为其然也?”客曰:“月明星稀,乌鹊南飞,此非曹孟德之诗乎?西望夏口,东望武昌,山川相缪,郁乎苍苍,此非孟德之困于周郎者乎?方其破荆州,下江陵,顺流而东也,舳舻千里,旌旗蔽空,酾酒临江,横槊赋诗,固一世之雄也,而今安在哉?况吾与子渔樵于江渚之上,侣鱼虾而友麋鹿,驾一叶之扁舟,举匏樽以相属。寄蜉蝣于天地,渺沧海之一粟。哀吾生之须臾,羡长江之无穷。挟飞仙以遨游,抱明月而长终。知不可乎骤得,托遗响于悲风。”
苏子曰:“客亦知夫水与月乎?逝者如斯,而未尝往也;盈虚者如彼,而卒莫消长也。盖将自其变者而观之,则天地曾不能以一瞬;自其不变者而观之,则物与我皆无尽也,而又何羡乎!且夫天地之间,物各有主,苟非吾之所有,虽一毫而莫取。惟江上之清风,与山间之明月,耳得之而为声,目遇之而成色,取之无禁,用之不竭,是造物者之无尽藏也,而吾与子之所共适。”
客喜而笑,洗盏更酌。肴核既尽,杯盘狼籍。相与枕藉乎舟中,不知东方之既白。