connecting Python 2.6.1 with MySQLdb

Question

Hi All 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

Answer 1

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

Answer 2

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/

Answer 3

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...

Answer 4

The best setup for Windows that I've found:

http://www.thescotties.com/mysql-python/test/

EDIT: Here's a more comprehensive list, that goes up to Python 2.7 as of 10/5/2010:

http://www.codegood.com/downloads

Answer 5

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!

Answer 6

thanks you guys! this has definitely helped! i have been scratching my head all day trying to build my own compiler. now i can focus on getting django started. thanks again!