Python Programming Tutorial - 48: Install MySql Connector for Python

In this tutorial we'll begin our discussion on using python to interact with MySql databases. We'll download and install the MySql connector for python and execute a few simple SQL statements at the end of the tutorial.

[dhruvi_it_fitness]

sir only u be the person who properly explains how to connect my_sql to python thank you sir

[shravanichetti]

Traceback (most recent call last):
File "<pyshell#1>", line 1, in <module>
import mysql.connector
ModuleNotFoundError: No module named 'mysql.connector'; 'mysql' is not a package
Even after the installation of the connector I'm getting this error

[Gamer-oiqy]

In my college they taught us in a very complicated method...this one was just so easy and did worked well.

[learnsimplebhima]

Good one, learned how to install MySql server and import into jupytor notebook.

[rizkianamunief]

what should I do next if I found this error when I try to import mysql.connector?
>>> import mysql.connector

Traceback (most recent call last):
File "<pyshell#0>", line 1, in <module>
import mysql.connector
ImportError: No module named mysql.connector

[dr.soodipneogi]

hi, i have installed mysql connector but i can only import mysql.connector for python 2.7 which comes with mac, though i have python3.5, but in python3.5 i get an error ImportError: no module named 'mysql'... please suggest for python3.5... many thanks

[sravani]

Traceback (most recent call last):
File "<pyshell#0>", line 1, in <module>
import mysql.connector
ModuleNotFoundError: No module named 'mysql'

this error shows up when i type "import mysql.connector"
please help me

[chaloyaaron]

i am using python 3.5..the mysql connector for python 3.5 hasn't been released yet..what should i do now??

[riteshagrawal]

Hi Madhur, I am using python 3.6.3. Cant find a mysql connector for it. Could you please suggest the solution for it

[oscaracostapulido]

good explanation, all is clear now, thanks man

[ziashahid]

sir what would be the procedure if we dont use the localhost, what changes can be done in setting up the sqlworkbench?? kindly help !!

[morvaridkardan]

Thank you for your helpful tutorial. I am wondering if mysql connector works the same as mysqlDB. Could you help me through that?

[tedtdu]

"python v3.4 not found".. what should to do to make it find it. I downloaded python3.4 exactly where it is expected

[deepjain]

I m currently working on version python3.3.3 and MySQL connector of puyhon3.3 is not available. What should I do?
Is it be ok to download connector 3.4 or 3.6?
Please suggest !!!

[harishlodhi]

hi i am using python 2.6.6, and i am not able to connect with database can u please help me

[MandeepSingh-pzrk]

sir, while downloading sql I got as issue that "This application requires Visual Studio 2015 Redistributable . Please install the Redistributable them run this installer again."
please tell me how can I start working with sql connector

[varunguptavarun]

Hi! I am using python 2.7 and I installed the SQL connector for the same. But when I run the command
conn=mysql.connector.connect(user='root', password='varun', host='localhost')
I am getting the following error message. could you please help me!?
Error: Can't connect to MySQL server on 'localhost:3306' (10061 No connection could be made because the target machine actively refused it)

[ramana]

Bro im getting an error saying no module named dns

[shubhambisht]

this error will shown what can i do plss resolve my problem

[miassus]

can anyone helps why it doesnt work and install properly on mac?