Install MySql Connector in Anaconda 2019.10

Command for mysql connector:
pip install mysql-connector

[swati]

Literally tried everything exhausted lost hope but finally you saved me thanks a big thanks

[manwendramahato]

Thankyou ! I watched many tutorials but finally this one worked ❤

[Naavy]

Been trying to fix this for 2 hours. Thanks so much. Works on Mac as well. Just saved me another 5 hours

[gustavomiranda]

Thank u so much!! I spent one day trying to install this driver, but only got it after your video... thank you again!

[uchiwa]

Thanks a lot been watching many videos but only this one helped. You r a lifesaver :)

[mithughosh]

Finally done
It worked.
Thanks a lot.

[adityasingh]

Really helpful video but guys if u r still getting error and specifically this one, "NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported", then use this command "pip install mysql-connector-python" rather than this, "pip install mysql-connector". I hope it helps.

[harichandanaghanta]

I can not thank you enough for this! I was about to give up using MySQL in Anaconda and then found this. It was very helpful. But I am curious to know why installing 'mysql-conncetor' via pip or conda did not work while it works for other packages like 'tensorflow'. Can you please explain?

[kushagradiwan]

Installed mysql connector but inspite still not able to access it in jupyter notebook.It works well in idle and pycharm but doesn't in jupyter. It shows the following error:
ModuleNotFoundError Traceback (most recent call last)
in <module>
----> 1 import mysql.connector


ModuleNotFoundError: No module named 'mysql'

please help!

[treecoolz]

Thanks thanks thanks....a lot for the video..👍👍👍👍👍👍😀😀😀

[samskii]

getting the below error
2003: Can't connect to MySQL server on 'localhost:3306' (10061 No connection could be made because the target machine actively refused it)

[jessicakaiser]

what happens when i do all of this and still getting a bunch of errors?? great when it just works like you show, but how do i troubleshoot now??!

[its_akanksha_]

Yesterday I downloaded connector it was working in Spyder but today it is not working it showed no module .Can you please give me some solution

[Avivahere]

thank you ahahahahah ... in so amazed thank you ... for Mac book users .. follow this

Code:

print()
print("Create Connection")
import mysql.connector
mydb = mysql.connector.connect(
host="localhost",
user="root"
print(mydb)