Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to install MySQLdb in Python 2.6 CentOS

I am getting this message when I use yum install mysql-python to install MySQLdb.

Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirrors.sin3.sg.voxel.net
 * extras: mirrors.sin3.sg.voxel.net
 * updates: mirrors.sin3.sg.voxel.net
base                                                      | 3.7 kB     00:00
extras                                                    | 3.4 kB     00:00
updates                                                   | 3.4 kB     00:00
Setting up Install Process
No package mysql-python available.
Error: Nothing to do

Update
Result for yum repolist

root@server [~]# yum repolist
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirrors.sin3.sg.voxel.net
 * extras: mirrors.sin3.sg.voxel.net
 * updates: mirrors.sin3.sg.voxel.net
base                                     | 3.7 kB     00:00
extras                                   | 3.4 kB     00:00
updates                                  | 3.4 kB     00:00
repo id              repo name                        status
base                 CentOS-6 - Base                  6,019+362
extras               CentOS-6 - Extras                13
updates              CentOS-6 - Updates               802+140
repolist: 6,834
like image 739
kagat-kagat Avatar asked Jul 12 '13 17:07

kagat-kagat


People also ask

How do I install mysqldb in Python?

How do I Install MySQLdb in Python? Before proceeding, you make sure you have MySQLdb installed on your machine. Just type the following in your Python script and execute it − If it produces the following result, then it means MySQLdb module is not installed − Note − Make sure you have root privilege to install above module.

How do I install MySQL on Ubuntu and Fedora?

For Ubuntu, use the following command - $ sudo apt-get install python-pip python-dev libmysqlclient-dev For Fedora, use the following command - $ sudo dnf install python python-devel mysql-devel redhat-rpm-config gcc For Python command prompt, use the following command - pip install MySQL-python

Is it possible to connect to a MySQL database with Python?

I am using python programs on a few ubuntu machines that connect to various mysql databases, all working fine using mysqldb in the python script.


1 Answers

You can install it via yum, it is case sensitive:

[root@localhost ~]# yum install MySQL-python
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirrors.nfsi.pt
 * extras: mirrors.nfsi.pt
 * updates: mirrors.nfsi.pt
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package MySQL-python.x86_64 0:1.2.3-0.3.c1.1.el6 will be installed
--> Finished Dependency Resolution
...

It works with the following repositories (CentOS 6):

[root@localhost ~]# yum repolist
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirrors.nfsi.pt
 * extras: mirrors.nfsi.pt
 * updates: mirrors.nfsi.pt
repo id      repo name            status
base         CentOS-6 - Base      6.381
extras       CentOS-6 - Extras    12
updates      CentOS-6 - Updates   458
repolist: 6.851
like image 55
jabaldonedo Avatar answered Oct 21 '22 14:10

jabaldonedo