Django1.9中的Mysql连接问题

Question

我在尝试连接mysql数据库时遇到以下错误

[Fri Mar 31 09:04:54.154874 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314] mod_wsgi (pid=16451): Target WSGI script '/home/abhadran/network_python3/netmap/netmap/wsgi.py' cannot be loaded as Python module.
[Fri Mar 31 09:04:54.154920 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314] mod_wsgi (pid=16451): Exception occurred processing WSGI script '/home/abhadran/network_python3/netmap/netmap/wsgi.py'.
[Fri Mar 31 09:04:54.154942 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314] Traceback (most recent call last):
[Fri Mar 31 09:04:54.154960 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314]   File "/home/abhadran/network_python3/netmap/netmap/wsgi.py", line 21, in <module>
[Fri Mar 31 09:04:54.156034 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314]     application = get_wsgi_application()
[Fri Mar 31 09:04:54.156062 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314]   File "/home/webdev01/pythonev3/lib/python3.5/site-packages/django/core/wsgi.py", line 13, in get_wsgi_application
[Fri Mar 31 09:04:54.156125 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314]     django.setup()
[Fri Mar 31 09:04:54.156140 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314]   File "/home/webdev01/pythonev3/lib/python3.5/site-packages/django/__init__.py", line 18, in setup
[Fri Mar 31 09:04:54.156170 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314]     apps.populate(settings.INSTALLED_APPS)
[Fri Mar 31 09:04:54.156182 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314]   File "/home/webdev01/pythonev3/lib/python3.5/site-packages/django/apps/registry.py", line 108, in populate
[Fri Mar 31 09:04:54.156290 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314]     app_config.import_models(all_models)
[Fri Mar 31 09:04:54.156310 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314]   File "/home/webdev01/pythonev3/lib/python3.5/site-packages/django/apps/config.py", line 202, in import_models
[Fri Mar 31 09:04:54.156373 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314]     self.models_module = import_module(models_module_name)
[Fri Mar 31 09:04:54.156392 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314]   File "/usr/lib64/python2.7/importlib/__init__.py", line 37, in import_module
[Fri Mar 31 09:04:54.156462 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314]     __import__(name)
[Fri Mar 31 09:04:54.156478 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314]   File "/home/webdev01/pythonev3/lib/python3.5/site-packages/django/contrib/auth/models.py", line 4, in <module>
[Fri Mar 31 09:04:54.156614 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314]     from django.contrib.auth.base_user import AbstractBaseUser, BaseUserManager
[Fri Mar 31 09:04:54.156636 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314]   File "/home/webdev01/pythonev3/lib/python3.5/site-packages/django/contrib/auth/base_user.py", line 49, in <module>
[Fri Mar 31 09:04:54.156715 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314]     class AbstractBaseUser(models.Model):
[Fri Mar 31 09:04:54.156732 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314]   File "/home/webdev01/pythonev3/lib/python3.5/site-packages/django/db/models/base.py", line 108, in __new__
[Fri Mar 31 09:04:54.157044 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314]     new_class.add_to_class('_meta', Options(meta, app_label))
[Fri Mar 31 09:04:54.157061 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314]   File "/home/webdev01/pythonev3/lib/python3.5/site-packages/django/db/models/base.py", line 307, in add_to_class
[Fri Mar 31 09:04:54.157078 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314]     value.contribute_to_class(cls, name)
[Fri Mar 31 09:04:54.157098 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314]   File "/home/webdev01/pythonev3/lib/python3.5/site-packages/django/db/models/options.py", line 263, in contribute_to_class
[Fri Mar 31 09:04:54.157316 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314]     self.db_table = truncate_name(self.db_table, connection.ops.max_name_length())
[Fri Mar 31 09:04:54.157335 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314]   File "/home/webdev01/pythonev3/lib/python3.5/site-packages/django/db/__init__.py", line 36, in __getattr__
[Fri Mar 31 09:04:54.157383 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314]     return getattr(connections[DEFAULT_DB_ALIAS], item)
[Fri Mar 31 09:04:54.157398 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314]   File "/home/webdev01/pythonev3/lib/python3.5/site-packages/django/db/utils.py", line 212, in __getitem__
[Fri Mar 31 09:04:54.157479 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314]     backend = load_backend(db['ENGINE'])
[Fri Mar 31 09:04:54.157492 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314]   File "/home/webdev01/pythonev3/lib/python3.5/site-packages/django/db/utils.py", line 116, in load_backend
[Fri Mar 31 09:04:54.157505 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314]     return import_module('%s.base' % backend_name)
[Fri Mar 31 09:04:54.157513 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314]   File "/usr/lib64/python2.7/importlib/__init__.py", line 37, in import_module
[Fri Mar 31 09:04:54.157523 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314]     __import__(name)
[Fri Mar 31 09:04:54.157529 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314]   File "/home/webdev01/pythonev3/lib/python3.5/site-packages/django/db/backends/mysql/base.py", line 28, in <module>
[Fri Mar 31 09:04:54.157625 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314]     raise ImproperlyConfigured("Error loading MySQLdb module: %s" % e)
[Fri Mar 31 09:04:54.157650 2017] [wsgi:error] [pid 16451] [remote 173.1.101.95:62314] ImproperlyConfigured: Error loading MySQLdb module: this is MySQLdb version (1, 3, 10, 'final', 0), but _mysql is version (1, 2, 3, 'final', 0)

我正在使用Django1.9版本和python3.5.3。我手动安装了python。是不是因为这个问题？？。即使在取消安装mysql客户端之后，我也会遇到上述错误。你知道吗

皮普冻结

configparser2==4.0.0
Django==1.9.12
django-tastypie==0.13.3
mod-wsgi==4.5.15
python-dateutil==2.6.0
python-mimeparse==1.6.0
requests==2.13.0
six==1.10.0

Answer 1

安装PyMySQL，然后在settings.py中，在import os下面键入以下命令。你知道吗

try:
    import pymysql
    pymysql.install_as_MySQLdb()
except:
    pass

Answer 2

import PyMySQL

PyMySQL是python连接mysql的接口。 可使用下载

pip install PyMySQL

也可以使用mysqlclient。你知道吗

pip install mysqlclient.

Answer 3

你能试试这个吗？你知道吗

pip install MySQL-python

我就是这样让MySQL与Django一起工作的（尽管使用的是1.8.8版本）。你知道吗