# 1 Connecting Python and MySQL in IDLE/Jupyter Notebooks.

#PYTHON #MySQL #CONNECTION

[HammerHead]

Thank you so much. This video is old and I ran into some bugs trying your method, but I managed to figure them out. Leaving this comment here in case I have to come back to it on a different computer.

For the IDLE app: At about 2:53, you say to type "pip install mysql-connector", and unfortunately at the time of this comment, this is depreciated. Instead use "pip install mysql-connector-python". At 4:15 I noticed you did a ninja edit where you changed the "mydb = sql.connector" line to "mydb = sql.connect" and this is important. Finally, I was confused because I had multiple Python versions installed. 3.9, 3.10 and 3.11 (I know bad practice on my part). Make sure you are using the same version for both pip install and IDLE shell.

For Jupyter Notebook: I ran into another error when I tried to run the mydb command, which was Authentication plugin 'caching_sha2_password' is not supported". To solve this, I created a cell and ran "pip install mysql-connector-python" prior to trying it again.

[sheikhshahbaz]

I was in trouble as how to connect to mysql . But this video resolves it . These commands really work . Thankyou Shabbir for this awesome video....

[kunalrajput]

Thanks bro lot of video I watched but you did it

[Ankurkumar]

Very informative....thanks a lot for sharing :)

[sresthasvlog]

Many Many Thanks.... This video solved my problem. Thanks a lot.

[pranaypv]

Scripts -showing the system cannot find path

[JULIUS_]

after writing cd Scripts it still shows the system cannot find the path specified... what am I supposed to do now?

[nextdoortechieaminfirnash]

Thanks Bro for the video. Do more videos like this.

[ankurr]

😢 ERROR :No module named 'mysql.connector'

[thegbfolks]

In my case it is showing connection refused error. Please help me how to resolve this issue.

[priyankaballa]

I am getting this error... Authentication plugin 'caching_sha2_password' is not supported
when trying to create a connection between jupyter notebook and mysql....
Kindly guide how to resolve

[VishalKRaj-ge]

bro i am getting error as
ModuleNotFoundError Traceback (most recent call last)
Cell In[5], line 1
----> 1 import Mysql.connector as sqltor
3 mydb = sqltor.connect(host="localhost", user="root", passwd="root", use_pure = true)
5 print(mydb)

ModuleNotFoundError: No module named 'Mysql'

[sakshamsingh]

Mysql is connected toh jupyter but when i am using import mysql.connector in shell its showing module not found

[manikantasai]

I tried with : pip install mysql-connector-python it worked ..

[lavishsehgal]

it's showing no module named mysql and I have already installed the pip