Error in importing MySQL connector in Python 3.5

mysql python-3.x mysql-connector-python
docneogi picture docneogi · Nov 18, 2015 · Viewed 14.5k times · Source

I am getting ImportError: No module named 'mysql' while I do the following...

>>> import mysql.connector

MySQL is installed and am on Python 3.5. I can't figure out. The above command is running fine in Python 2.7.

Answer

Suresh2692 picture Suresh2692 · Mar 14, 2016

Unfortunately there is no mysql-connector available for python3.5.

So, you can use pymysql module which is a replacement for mysql-connector package

pip install pymysql

import pymysql
Connection = pymysql.connect(host='hostname', user='username', password='password', 
             db='database',charset='utf8mb4',cursorclass=pymysql.cursors.DictCursor )
ExecuteQuery(Connection)
Connection.close()

Related questions

What are the differences between mysql-connector-python, mysql-connector-python-rf and mysql-connector-repackaged?

I'd like to use the mysql-connector library for python 3. I could use pymysql instead, but mysql-connector already has a connection pool implementation, while pymysql doesn't seem to have one. So this would be less code for me to write. However, …

Read More
How can I connect to MySQL in Python 3 on Windows?

I am using ActiveState Python 3 on Windows and wanted to connect to my MySQL database. I heard that mysqldb was the module to use. I can't find mysqldb for Python 3. Is there a repository available where the binaries exist for …

Read More
Python 3.4.0 with MySQL database

I have installed Python version 3.4.0 and I would like to do a project with MySQL database. I downloaded and tried installing MySQLdb, but it wasn't successful for this version of Python. Any suggestions how could I fix this problem and …

Read More