Comments

Nick Coghlan

Fri Nov 4 2011, 00:25

Even better is to use the pip installer: http://pypi.python.org/pypi/pip

$ pip install mysql-connector

(pip does the same job as setuptools, but without messing with the system Python install the way setuptools does)

Geert Vanderkelen

Fri Nov 4 2011, 07:00

@Nick Coghlan Thanks for reminding me about pip! I’m so used to easy_install.. Updating my post.

Daniel Gerep

Sun Nov 13 2011, 01:22

Hi Geert, this is my first time with Python and thanks you I’ve found a practical way to install MySQL connector on Python but Im having difficulties, so if you can help me…

I have used pip to install the connector but when I try to install MySQLdb it gives me this error:

Traceback (most recent call last): File “C:\Python27\downloads\MySQL-python-1.2.3\setup.py”, line 15, in

metadata, options = get_config()

File “C:\Python27\downloads\MySQL-python-1.2.3\setup_windows.py”, line 7, in g et_config serverKey = _winreg.OpenKey(_winreg.HKEY_LOCAL_MACHINE, options[‘registry_ke y’]) WindowsError: [Error 2] The system cannot find the file specified

I’m using Windows x64 and I have created on regedit under Wow6432Node a Python node, the same created by the installer under SOFTWARE. I have added C:\Python27\Scripts on my PATH

Any idea?

Thanks in advance for any help.

Geert Vanderkelen

Sun Nov 13 2011, 09:52

@Daniel Gerep 1) MySQLdb is not MySQL Connector/Python. If you want to use Connector/Python, you are not using the command line posted in my blog. 2) I’m not Windows savvy enough to help you but it seems it can’t really find the file it wants.

Marco Massenzio

Mon Sep 3 2012, 05:39

Hi Geert,

there seems to be a problem with mysql-connector and pypi:

$ easy_install mysql-connector Searching for mysql-connector Reading http://pypi.python.org/simple/mysql-connector/ Couldn’t find index page for ‘mysql-connector’ (maybe misspelled?) Scanning index of all packages (this may take a while) Reading http://pypi.python.org/simple/ No local packages or download links found for mysql-connector error: Could not find suitable distribution for Requirement.parse(‘mysql-connector’)

This seems to have been going on for quite some while: any idea for when it’ll be fixed? if at all?

thanks, Marco

Marco Massenzio

Mon Sep 3 2012, 05:41

BTW - pip install fails just as well:

$ pip install mysql-connector Downloading/unpacking mysql-connector Could not find any downloads that satisfy the requirement mysql-connector No distributions at all found for mysql-connector Storing complete log in /home/marco/.pip/pip.log

Geert Vanderkelen

Thu Sep 6 2012, 13:58

@Marco Massenzio The old development release was removed. The new name is ‘mysql-connector-python’ as explained in a more recent blog post: http://geert.vanderkelen.org/connectorpython-1-0-5-on-pypi/