how to install mysqldb connector, anaconda python distribution

1 view
Skip to first unread message

ms.szcz...@gmail.com

unread,
Aug 3, 2013, 9:23:29 AM8/3/13
to anac...@continuum.io
Hi,
I am starting my journey with Python using anaconda distribution.
I want to install mysqldb connector, however when I try to do this by running mysql windows installer,  setup will not continue as it says I do not have python installed. How can I make it recognize and use my anaconda distribution?

Or are there any other better ways of installing mysqldb connector?
Thanks and best regards,
Michal

jimb...@gmail.com

unread,
Aug 25, 2013, 8:47:08 PM8/25/13
to anac...@continuum.io
Same problem. Tried SQLAlchemy, which comes with Anaconda but the MySQL driver is missing.

If I try in Windows "pip install python-mysql" it will fail to compile it. 

Ivo Flipse

unread,
Sep 6, 2013, 10:27:07 AM9/6/13
to anac...@continuum.io
Have you tried the Windows installer from: http://www.lfd.uci.edu/~gohlke/pythonlibs/#mysql-python

This one worked for me.

sravan...@gmail.com

unread,
Dec 14, 2013, 7:56:45 PM12/14/13
to anac...@continuum.io
Hi ....

I have similar problem.  But I am using Mac OS X.  Can you help me find where can I get the mysqldb package to use it in Anaconda distribution.

Thanks
Sravani

bke...@gmail.com

unread,
Jan 24, 2014, 10:04:19 AM1/24/14
to anac...@continuum.io
Bump. A noob like me really needs a step-by-step tutorial from a naked Anaconda install to connecting to a remote (non-localhost) database.

kzu...@gmail.com

unread,
Jan 29, 2014, 1:03:25 PM1/29/14
to anac...@continuum.io, bke...@gmail.com

For just getting on with mysql access when faced with mysqldb installation issues, i've had decent success in the past with pymysql: http://www.pymysql.org  (buried but useful usage tip at: https://github.com/PyMySQL/PyMySQL/wiki/WhyPyMySQL ). Apparently SQLAlchemy also has a dialect for it, though i've only ever used it directly.

Anyhow might save you a headache, did for me!

- kz

brutus...@gmail.com

unread,
Mar 24, 2014, 1:42:36 AM3/24/14
to anac...@continuum.io, sravan...@gmail.com
Hello Sravani - did you ever get this issue resolved? I am dealing with the same thing in OSX 10.9

sravan...@gmail.com

unread,
Mar 24, 2014, 3:21:59 PM3/24/14
to anac...@continuum.io, brutus...@gmail.com
I think I used the following command to install mysqldb on OSX 10.9

      sudo pip install mysql-python

Hope this works for you too.

Cheers,
Sravani

vannucc...@gmail.com

unread,
Jul 15, 2014, 8:33:39 AM7/15/14
to anac...@continuum.io, jimb...@gmail.com
Hi,

same here! I'm new to Python. I'm running Anaconda on Ubuntu 12.
I've tried sudo apt-get install python-mysqldb and it seems to have been installed without any problem.

However when I try to import it get: ImportError: No module named MySQLdb

I have no idea how to solve this!

Thanks

vannucc...@gmail.com

unread,
Jul 15, 2014, 10:07:53 AM7/15/14
to anac...@continuum.io, jimb...@gmail.com, vannucc...@gmail.com
Guys,

I've resolved following the instructions in this link:

http://conjurecode.com/installing-mysqldb-for-python-on-ubuntu/

rwber...@gmail.com

unread,
Oct 23, 2014, 8:42:29 AM10/23/14
to anac...@continuum.io


Op zaterdag 3 augustus 2013 15:23:29 UTC+2 schreef Michal Szczecinski:,
I am starting my journey with Python using anaconda distribution.
...

Or are there any other better ways of installing mysqldb connector?

conda install mysql-python

Worked for me.

Michal Szczecinski

unread,
Nov 19, 2014, 8:16:00 AM11/19/14
to anac...@continuum.io, rwber...@gmail.com
Thanks, it does not work for me though.
And I have updated conda and anaconda to newest versions.

I am getting this:
Fetching package metadata: ..
Error: No packages found in current win-64 channels matching: mysql-python

sharmil...@gmail.com

unread,
Jun 30, 2016, 6:54:49 AM6/30/16
to Anaconda - Public
Hi,
i am also facing the same issue,can you please tell  me how did you solved this issue
Reply all
Reply to author
Forward
0 new messages