Python 3.4 (Anaconda) - MySQL connector

python mysql database anaconda connector
thesisstudent picture thesisstudent · Mar 1, 2015 · Viewed 18.1k times · Source

I installed Python 3.4 by installing Anaconda. Now I would like to read data out of a MySQL database from Python. Hence I tried installing the Connector/Python 2.0.3 (https://dev.mysql.com/downloads/connector/python) for Python 3.4.

After it finishes downloading, it says "Python v3.4 not found". I looked it up online and came to the conclusion that something might be wrong with my environment variables. When copy pasting the location of IPython (in the Anaconda folder), i.e. C:\Users\Julie\Anaconda3\python.exe "C:\Users\Julie\Anaconda3\Scripts/ipython-script.py", as the PATH variable, I still get the same problem.

Does anybody know how to resolve this? Thank you in advance!

Answer

sparrow picture sparrow · Nov 29, 2016

First go to the location of your conda.exe, for me it's:

cd C:\Program Files\Anaconda3\Scripts

Then install the package:

conda.exe install mysql-connector-python

Related questions

How do I get the "id" after INSERT into MySQL database with Python?

I execute an INSERT INTO statement cursor.execute("INSERT INTO mytable(height) VALUES(%s)",(height)) and I want to get the primary key. My table has 2 columns: id primary, auto increment height this is the other column. How do I …

Read More
Bulk insert with SQLAlchemy ORM

Is there any way to get SQLAlchemy to do a bulk insert rather than inserting each individual object. i.e., doing: INSERT INTO `foo` (`bar`) VALUES (1), (2), (3) rather than: INSERT INTO `foo` (`bar`) VALUES (1) INSERT INTO `foo` (`bar`) VALUES (2) INSERT INTO `…

Read More
Switching from SQLite to MySQL with Flask SQLAlchemy

I have a site that I've built with Flask SQLAlchemy and SQLite, and need to switch to MySQL. I have migrated the database itself and have it running under MySQL, but Can't figure out how to connect to the MySQL …

Read More