时间戳

首页 > 解决方案 > 将 mysql 8 与 django 连接时出错

mysql - 将 mysql 8 与 django 连接时出错

问题描述

我正在使用 python 3.6、mysql-community-server-8.0.11-1 并使用 fedora 28 我正在尝试为我的 django 应用程序设置 mysql 但我收到分段错误

(myblogvenv) [saurabhkumar@localhost myblog]$ python manage.py runserver
Performing system checks...
Segmentation fault (core dumped)

如果我使用默认的 sqlite3 数据库，服务器就会启动。

此外，当我运行时，django-admin dbshell我收到以下错误：

(myblogvenv) [saurabhkumar@localhost myblog]$ django-admin dbshell
    Traceback (most recent call last):
    File "/run/media/saurabhkumar/9bba3767-3aa7-4b39-a4a7- 
 331f939ae4d9/django_projects/common_lounge/myblog/myblogvenv/bin/django- 
    admin", line 11, in <module>
    sys.exit(execute_from_command_line())
  File "/run/media/saurabhkumar/9bba3767-3aa7-4b39-a4a7-331f939ae4d9/django_projects/common_lounge/myblog/myblogvenv/lib/python3.6/site-packages/django/core/management/__init__.py", line 371, in execute_from_command_line
    utility.execute()
  File "/run/media/saurabhkumar/9bba3767-3aa7-4b39-a4a7-331f939ae4d9/django_projects/common_lounge/myblog/myblogvenv/lib/python3.6/site-packages/django/core/management/__init__.py", line 317, in execute
    settings.INSTALLED_APPS
  File "/run/media/saurabhkumar/9bba3767-3aa7-4b39-a4a7-331f939ae4d9/django_projects/common_lounge/myblog/myblogvenv/lib/python3.6/site-packages/django/conf/__init__.py", line 56, in __getattr__
    self._setup(name)
  File "/run/media/saurabhkumar/9bba3767-3aa7-4b39-a4a7-331f939ae4d9/django_projects/common_lounge/myblog/myblogvenv/lib/python3.6/site-packages/django/conf/__init__.py", line 43, in _setup
    self._wrapped = Settings(settings_module)
  File "/run/media/saurabhkumar/9bba3767-3aa7-4b39-a4a7-331f939ae4d9/django_projects/common_lounge/myblog/myblogvenv/lib/python3.6/site-packages/django/conf/__init__.py", line 106, in __init__
    mod = importlib.import_module(self.SETTINGS_MODULE)
  File "/home/saurabhkumar/anaconda3/lib/python3.6/importlib/__init__.py", line 126, in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
  File "<frozen importlib._bootstrap>", line 994, in _gcd_import
  File "<frozen importlib._bootstrap>", line 971, in _find_and_load
  File "<frozen importlib._bootstrap>", line 941, in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
  File "<frozen importlib._bootstrap>", line 994, in _gcd_import
  File "<frozen importlib._bootstrap>", line 971, in _find_and_load
  File "<frozen importlib._bootstrap>", line 953, in _find_and_load_unlocked
  ModuleNotFoundError: No module named 'mysite'

这是我的项目结构：

(myblogvenv) [saurabhkumar@localhost myblog]$ ls
db.sqlite3  manage.py  myblogvenv  mysite
(myblogvenv) [saurabhkumar@localhost myblog]$ cd mysite
(myblogvenv) [saurabhkumar@localhost mysite]$ ls
__init__.py  __pycache__  settings.py  urls.py  wsgi.py

settings.py 中的数据库部分看起来像

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'blog',
        'USER': 'bloguser',
        'PASSWORD': 'Blog#user1',
        'HOST': '/var/lib/mysql',
        'PORT': '3306',
    }
}

使用以下软件包

(myblogvenv) [saurabhkumar@localhost mysite]$ pip list
Package     Version
----------- -------
Django      2.0.6  
mysqlclient 1.3.12 
pip         10.0.1 
pytz        2018.4 
setuptools  39.2.0 
wheel       0.31.1

有关如何调试/修复问题的任何指示都将帮助我继续。

标签： mysqldjangopython-3.x

解决方案

推荐阅读