CODEWITHSUNDEEP
pythonmysql
SKSK
SKSK

Reputation: 1273

connecting Python 2.6.1 with MySQLdb

I am using Python 2.6.1 and I want to connect to MySQLdb, I installed mySQL in my system, and I am trying to connect MySQL-python-1.2.2.win32-py2.6 from http://www.codegood.com/archives/4 site but its not working while running my application its saying that No module named MySQLdb

please any one provide me the proper setup for MySQLdb.

thanks in advance

Upvotes: 4

Views: 9492

Answers (6)

Abhishek Dujari
Abhishek Dujari

Reputation: 2453

I went for compiled binary , thats the best way to go on windows. There is a good source maintained by someone. I wrote about it here before because some months down the lane I will forget how I solved this and be searching Stack again :/ http://vangel.3ezy.com/archives/101-Python-2.4-2.5-2.6-and-2.7-Windows-MySQLdb-python-installation.html

Upvotes: 0

ojrac
ojrac

Reputation: 13421

The best setup for Windows that I've found:

http://www.codegood.com/downloads?dl_cat=2

EDIT: Removed original link (it's an ad farm now :( )

Upvotes: 13

clams1
clams1

Reputation: 21

I was having this problem and then I realised I was importing MySQLdb erroneously - it's case sensitive:

Incorrect: >>>import mysqldb

Correct: >>>import MySQLdb

Silly mistake, but cost me a few hours!

Upvotes: 2

Dave Everitt
Dave Everitt

Reputation: 17871

See this post on the mysql-python blog: MySQL-python-1.2.3 beta 2 released - dated March 2009. Looks like MySQLdb for Python 2.6 is still a work in progress...

Upvotes: 0

mariotomo
mariotomo

Reputation: 9758

generally, (good) python modules provide a 'setup.py' script that takes care of things like proper installation (google for 'distutils python'). MySQLdb is a "good" module in this sense.

since you're using windows, things might be a bit more complex. I assume you already installed MySQLdb following the instructions and it still gives this problem. what I would do is open a cmd.exe window, cd to the directory containing the 'setup.py' script and there type something like C:\Python26\Python.exe setup.py install

if this does not work, then grab the module somewhere else, maybe at the place where it is actively developed: http://sourceforge.net/projects/mysql-python/

Upvotes: 0

CMB
CMB

Reputation: 456

The module is not likely in your python search path..

Check to see if that module is in your Python Path... In windows...you may find it in the registry

HKLM\Software\Python\PythonCore\2.6\PythonPath

Be careful editing it...

You may also alter the Python Path programmaticly by the following

import sys
sys.path.append('somepath_to_the_module_you_wanted')

import the_module_you_wanted

Hope that helps

Upvotes: 4

Related Questions