如何使用pip安装Python的MySQLdb模块?
当前回答
如果你无法安装mysqlclient,你也可以安装pymysql:
安装pymysql
这与MySqldb的工作原理相同。之后使用pymysql代替MySQLdb
其他回答
我尝试了所有的选项,但不能让它在红帽平台上工作。 我做了下面的工作:-
yum install MySQL-python -y
一旦包被安装,就可以在解释器中导入模块如下
>>> import MySQLdb
>>>
从新的Ubuntu 14.04.2系统开始,需要这两个命令:
apt-get install python-dev libmysqlclient-dev
pip install MySQL-python
仅仅自己进行“pip安装”是行不通的。
从http://codeinthehole.com/writing/how-to-set-up-mysql-for-python-on-ubuntu/
第一个
pip install pymysql
然后将下面的代码放入__init__.py (projectname/__init__.py)
import pymysql
pymysql.install_as_MySQLdb()
我的环境是(python3.5, django1.10),这个解决方案适合我!
希望这能有所帮助!!
如果你使用的是树莓派(Raspberry Pi)
首先需要安装pip命令
apt-get install python-pip
这就是按顺序安装
apt-get install python-dev libmysqlclient-dev
apt-get install python-pip
pip install MySQL-python
实际上,遵循@Nick T的答案对我不起作用,我尝试apt-get install python-mysqldb对我有效
root@2fb0da64a933:/home/test_scrapy# apt-get install python-mysqldb
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following additional packages will be installed:
libmariadbclient18 mysql-common
Suggested packages:
default-mysql-server | virtual-mysql-server python-egenix-mxdatetime python-mysqldb-dbg
The following NEW packages will be installed:
libmariadbclient18 mysql-common python-mysqldb
0 upgraded, 3 newly installed, 0 to remove and 29 not upgraded.
Need to get 843 kB of archives.
After this operation, 4611 kB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 http://deb.debian.org/debian stretch/main amd64 mysql-common all 5.8+1.0.2 [5608 B]
Get:2 http://deb.debian.org/debian stretch/main amd64 libmariadbclient18 amd64 10.1.38-0+deb9u1 [785 kB]
Get:3 http://deb.debian.org/debian stretch/main amd64 python-mysqldb amd64 1.3.7-1.1 [52.1 kB]
Fetched 843 kB in 23s (35.8 kB/s)
debconf: delaying package configuration, since apt-utils is not installed
Selecting previously unselected package mysql-common.
(Reading database ... 13223 files and directories currently installed.)
Preparing to unpack .../mysql-common_5.8+1.0.2_all.deb ...
Unpacking mysql-common (5.8+1.0.2) ...
Selecting previously unselected package libmariadbclient18:amd64.
Preparing to unpack .../libmariadbclient18_10.1.38-0+deb9u1_amd64.deb ...
Unpacking libmariadbclient18:amd64 (10.1.38-0+deb9u1) ...
Selecting previously unselected package python-mysqldb.
Preparing to unpack .../python-mysqldb_1.3.7-1.1_amd64.deb ...
Unpacking python-mysqldb (1.3.7-1.1) ...
Setting up mysql-common (5.8+1.0.2) ...
update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Setting up libmariadbclient18:amd64 (10.1.38-0+deb9u1) ...
Processing triggers for libc-bin (2.24-11+deb9u3) ...
Setting up python-mysqldb (1.3.7-1.1) ...
root@2fb0da64a933:/home/test_scrapy# python
Python 2.7.13 (default, Nov 24 2017, 17:33:09)
[GCC 6.3.0 20170516] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import MySQLdb
>>>
推荐文章
- 如何解窝(爆炸)在一个熊猫数据帧列,成多行
- 如何使用pip安装opencv ?
- 在pip冻结命令的输出中“pkg-resources==0.0.0”是什么
- 格式y轴为百分比
- 熊猫连接问题:列重叠但没有指定后缀
- 为什么空字典在Python中是一个危险的默认值?
- 在Python中,冒号等于(:=)是什么意思?
- Python "SyntaxError:文件中的非ascii字符'\xe2' "
- 如何从psycopg2游标获得列名列表?
- Python中dict对象的联合
- 如何有效地比较两个无序列表(不是集合)?
- 如何在交互式Python中查看整个命令历史?
- 如何显示有两个小数点后的浮点数?
- 在MySQL中检测值是否为number
- MySQL中两个日期之间的差异