django安装mysql驱动-创新互联

django目前支持三种mysql驱动来进行mysql的链接

创新互联建站网络公司拥有十多年的成都网站开发建设经验,近千家客户的共同信赖。提供网站建设、成都网站设计、网站开发、网站定制、买链接、建网站、网站搭建、成都响应式网站建设、网页设计师打造企业风格,提供周到的售前咨询和贴心的售后服务
  • MySQLdb is a native driver that has been developed and supported for over a decade by Andy Dustman.

  • mysqlclient is a fork ofMySQLdbwhich notably supports Python 3 and can be used as a drop-in replacement for MySQLdb. At the time of this writing, this isthe recommended choicefor using MySQL with Django.

  • MySQL Connector/Python is a pure Python driver from Oracle that does not require the MySQL client library or any Python modules outside the standard library.

mysqldb 目前不支持python3+,推荐使用mysqlclient

尝试了在pycharm上直接安装mysqlclient,报以下错误:OSError: mysql_config not found

在git上查阅安装步骤:

Prerequisites

You may need to install the Python and MySQL development headers and libraries like so:

sudo apt-get install python-dev libmysqlclient-dev # Debian / Ubuntu

sudo yum install python-devel mysql-devel # Red Hat / CentOS

On Windows, there are binary wheel you can install without MySQLConnector/C or MSVC.

Note on Python 3 : if you are using python3 then you need to install python3-dev using the following command :

sudo apt-get install python3-dev # debian / Ubuntu

sudo yum install python3-devel # Red Hat / CentOS

brew install mysql-connector-c # macOS (Homebrew)

Install from PyPI

pip install mysqlclient

因为我在mac上,使用的python3,故先执行命令:

brew install mysql-connector-c

然后再执行:

pip3 install mysqlclient

报如下错误:

Command "python setup.py egg_info" failed with error code 1 in /private/tmp/pip-build-m9v70gan/mysqlclient/

这个地方有点疑惑:使用pip3命令后,最终调用的是python,而不是python3

查看mysqlclient的源代码,发现根本原因还是因为没找到mysql_config,明白过来需要安装mysql,才能正常安装mysqlclient

Installed /Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/mysqlclient-1.3.10-py3.6-macosx-10.6-intel.egg

Processing dependencies for mysqlclient==1.3.10

Finished processing dependencies for mysqlclient==1.3.10


分享文章:django安装mysql驱动-创新互联
本文路径:http://azwzsj.com/article/djoceo.html