如何使用pip安装Python的MySQLdb模块?
当前回答
这招对我很管用:
pip install mysqlclient
这是针对python 3.x的
其他回答
在RHEL 7:
Sudo yum安装yum-utils mariadb-devel python-pip python-devel GCC
sudo /bin/pip2 install MySQL-python
如果你的系统上安装了Windows,那么在cmd上输入以下命令:
pip install mysql-connector
如果上述命令不起作用,请尝试使用:
pip install mysql-connector-python
现在,如果上面的命令不能完成工作,尝试使用:
pip install mysql-connector-python-rf
好了,你现在可以走了。
我尝试了所有的选项,但不能让它在红帽平台上工作。 我做了下面的工作:-
yum install MySQL-python -y
一旦包被安装,就可以在解释器中导入模块如下
>>> import MySQLdb
>>>
实际上,遵循@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
>>>
从新的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/
推荐文章
- 子进程Popen和调用之间的区别是什么(我如何使用它们)?
- 将python 'type'对象转换为字符串
- 在pytest测试中记录日志
- 为什么MYSQL的高LIMIT偏移量减慢查询?
- .join()方法到底做什么?
- MySQL选择列不为空的位置
- 哪个更快:多个单个INSERT还是一个多行INSERT?
- 我如何知道一个生成器从一开始就是空的?
- 搜索mysql数据库中出现的所有字符串
- Python中的SFTP ?(平台无关)
- 使用Python将XML转换为JSON ?
- 如何修改文本文件?
- 如何更改默认的Anaconda python环境
- 在pandas应用函数中获取一行的索引
- 为什么PyCharm提议将方法改为静态?