刨根问底,完美解决Django2版本连接MySQL报错的问题「建议收藏」

(你的Python解释器安装目录或者虚拟环境目录)django21Libsite-packagesdjangodbackendsmysqlbase.py

代码100分

代码100分"""
MySQL database backend for Django.

Requires mysqlclient: https://pypi.org/project/mysqlclient/ # 之前没安装的话得从pypi中下载mysqlclient包 """
import re

from django.core.exceptions import ImproperlyConfigured
from django.db import utils
from django.db.backends import utils as backend_utils
from django.db.backends.base.base import BaseDatabaseWrapper
from django.utils.functional import cached_property

try:
    import MySQLdb as Database # 导入MySQLdb模块 except ImportError as err:
    raise ImproperlyConfigured(
        "Error loading MySQLdb module.
"
        "Did you install mysqlclient?"
    ) from err

from MySQLdb.constants import CLIENT, FIELD_TYPE                # isort:skip
from MySQLdb.converters import conversions                      # isort:skip

# Some of these import MySQLdb, so import them after checking if it"s installed.
from .client import DatabaseClient                          # isort:skip
from .creation import DatabaseCreation                      # isort:skip
from .features import DatabaseFeatures                      # isort:skip
from .introspection import DatabaseIntrospection            # isort:skip
from .operations import DatabaseOperations                  # isort:skip
from .schema import DatabaseSchemaEditor                    # isort:skip
from .validation import DatabaseValidation                  # isort:skip
 version = Database.version_info
# 打印一下这个version print("version>>>>>>",version) if version < (1, 3, 7):
    raise ImproperlyConfigured("mysqlclient 1.3.7 or newer is required; you have %s." % Database.__version__)

###################
and so on...

try:
    import MySQLdb as Database
    # 打印一下这个Database
    print(Database,type(Database)) except ImportError as err:
    raise ImproperlyConfigured(
        "Error loading MySQLdb module.
"
        "Did you install mysqlclient?"
    ) from err

代码100分import pymysql  # 导入模块相当于执行了这个包中的__init__.py文件

pymysql.install_as_MySQLdb() # 执行pymysql的install_as_MySQLdb方法

"""
PyMySQL: A pure-Python MySQL client library.

### 说明略去
"""
import sys

from ._compat import PY2
from .constants import FIELD_TYPE
from .converters import escape_dict, escape_sequence, escape_string
from .err import (
    Warning, Error, InterfaceError, DataError,
    DatabaseError, OperationalError, IntegrityError, InternalError,
    NotSupportedError, ProgrammingError, MySQLError)
from .times import (
    Date, Time, Timestamp,
    DateFromTicks, TimeFromTicks, TimestampFromTicks)

# pymysql的版本
VERSION = (0, 9, 3, None) if VERSION[3] is not None:
    VERSION_STRING = "%d.%d.%d_%s" % VERSION
else:
    VERSION_STRING = "%d.%d.%d" % VERSION[:3]
threadsafety = 1
apilevel = "2.0"
paramstyle = "pyformat"


class DBAPISet(frozenset):

    # 省略

# 省略

def Binary(x):
    """Return x as a binary type."""
    # 省略

def Connect(*args, **kwargs):
    """
    Connect to the database; see connections.Connection.__init__() for
    more information.
    """
    # 省略

from . import connections as _orig_conn
if _orig_conn.Connection.__init__.__doc__ is not None:
    Connect.__doc__ = _orig_conn.Connection.__init__.__doc__
del _orig_conn


def get_client_info():  # for MySQLdb compatibility
    version = VERSION
    if VERSION[3] is None:
        version = VERSION[:3]
    return ".".join(map(str, version))

connect = Connection = Connect

# we include a doctored version_info here for MySQLdb compatibility
version_info = (1, 3, 12, "final", 0)

NULL = "NULL"

__version__ = get_client_info()

def thread_safe():
    return True  # match MySQLdb.thread_safe()


### 这里是最关键的
def install_as_MySQLdb(): """
    After this function is called, any application that imports MySQLdb or
    _mysql will unwittingly actually use pymysql.
    """
 ### 导入MySQLdb、_mysql其实相当于导入了pymysql模块！！！ sys.modules["MySQLdb"] = sys.modules["_mysql"] = sys.modules["pymysql"] __all__ = [
    # 略去
]

pip install pymysql==0.9.3 -i https://pypi.douban.com/simple

[root@mycentos ~]# /opt/py3.6/ve1/bin/pip  install  xxx.whl

tar -xzvf  xxx.tar.gz
cd xxx

/opt/py3.6/ve1/bin/python setup.py install