One correction, if you are watching in 2022 @04:00 you might be getting "Authentication plugin 'caching_sha2_password' is not supported" error. Just uninstall mysql-connector & install mysql-connector-python.
Couple of years ago I used to be your channel fan for Java. However, now you're rocking in python. You're definitely a master of all trades. Kudos you talent
Pychram or Sublime error: if you have mysql 8.0.15 version , then you need to have mysql connector-8.0.15 Open Pycharm go to File->Settings-> Preferences->Project->Python Interpreter inside Pycharm, and search for mysql-connector-python and select version as 8.0.15 from dropdown list and click in install. for Sublime: go to command prompt, uninstall any old mysql connector pip3 uninstall mysql-connector C:\Users\Sanju>pip3 uninstall mysql-connector pip3 install mysql-connector-python C:\Users\Sanju>pip3 uninstall mysql-connector-python
I had the same situation, the way I solved was to go where python is located, in my case c:\users\myname\python\pip3 install mysql-connector, I hope this helps
if your cmd cant find pip or pip3 just go to python's official website and download the latest version of python and then try pip on your cmd , worked for me
Hi, Firstly I want to thank you for this useful video series. Could you please release the Oracle/Mango database connection and basic queries. A lot of people use these databases. Thank you so much.
as of november 6, 2019, line 3 from code at 3:39 won't work. instead do mydb = mysql.connector.connect(user='navin', password='1234', host='localhost', auth_plugin='mysql_native_password') and that works. you should also have 'mysql-connector-python' and 'mysql-connector' installed.
I am having this type of error "Authentication plugin '{0}' is not supported".format(plugin_name)) NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
Hey Navin, when I start working and earning a salary I'm donating I promise. I mean I am totally straight but I have never loved another man this much.
I recommend people to first uninstall mysql-connector and than install mysql-connector-python as there should clash between both of than while importing library
want to start by thanking you sincerely for all the effort you've put in-you're truly the best. After following your Python series, I feel confident that I've grasped all the key concepts. However, I'm wondering if you've covered Python scripting and Robot Framework somewhere, as I couldn't find any content on that in your channel. Could you please let me know if you've explained those topics? Thank you!
For those students whose output isn't showing properly first install the correct packages properly. Download Pycharm community edition first then got to File then settings. Over there under python interpreter click on the plus icon on top and search mysql-connector-python. Download it and your good to go.!!!
5:47 I got no result when I ran the code after following all the steps. I tried to reinstall the MYSQL server with the SHA password authentication option instead of the legacy authentication. The code now returns the desired output.
hey uma I was also getting the same problem. To solve it just see the video of setting up the path video from this playlist and then try cmd prompt pip3/3.7(depends upon the version you are using) install MySQL-connector
Thanking You for kind this Stuff and Encouragement...this is really best to everyone.. You are a real master, without skip any , and u thought as everything which is related to Python...
If you guys getting error like me go to the folder where Python is installed press shift+RMB and click open PowerShell here and write the code below : C:\Users\thede\AppData\Local\Programs\Python\Python38> py -m pip install mysql-connector
Great job Navin. Your series have been really helpful. I've learnt a lot. I'd appreciate if you can do also on Big data using python. Looking forward to it so much.
I don't know anything about MySQL, so I got the message. I need to learn it, first I will finish this playlist and learning MySQL will be my next endeavour. A BIG thank you to the whole team behind this effort.
mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on 'localhost:3306' ( No connection could be made because the target machine actively refused it) if you are getting this error maybe you changed port number , don't uninstall that just change back port number
After install mysql.connector show error into Pycharm such as "ModuleNotFoundError: No module named 'mysql.connector'". Now pl give suggestion, what to do ?
in sublime the message Can't connect to MySQL server on 'localhost:3306' (10061 No connection could be made because the target machine actively refused it) also appears.
Sir , I have installed MySQL and had run the code in sublime editor ,but I have got error (MySQL module donot found) but when I run in python shell I got answer.plss ,help me sir
how to use sublime here do i need to install it first? if so, from where please guide me sir... thanks a ton for this series...lots of respect for you and your work...
Use the command mysql-connector-python rather than using mysql-connector while using the pip install....(if ypu are using the latest version of MySQL its 8.0.7 i guess) Regards:- Tanishq:)
Actually am getting a module not found error while running the python code on command prompt , so can u plz let me know y bcz i have already installed the connector but still i am unable to run d Python code
while putting in the "host" variable you put localhost there but if you were hosting this database on a website what were you supposed to put? The websites link or the ip address of that website?
sir, I am a complete beginner in python. I am learning python from it's word meaning, from you. But this video creating a fear that I need some programming background to watch upcoming playlist videos. Is it true sir. If yes please help me .....sir
sir, I have watched ur video, and got stuck with error, help me solving this "Authentication plugin '{0}' is not supported".format(plugin_name)) mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
It would be really useful...Recently i have done some project for which I needed a video like this very badly.. I've had to watch so many videos to complete it..Nobody is as good as u
Hello, I have made a face recognition model using open CV. I am accessing the trained data from my computer itself (local server). Now I wanted to extract my data from Cloud insted of local server. What should be my approach and how should I modify my code. Please guide me with this.
hello one question which database i should use for python for create web application?? a database with best speed an performance !! i use windows 10 .. and IDE Visual studio Code i want a database for python Which is not necessary to change it later to another database
How do I send the output parameter for a stored procedure from python? It keeps breaking saying I sent more args if I send an additional 0 or '@out' and if I don't send it, it asks for it.
Solution to Access Denied Error Run the same command which he ran initially but run cmd as an administrator. This can be done by right clicking on cmd and selecting run as administrator. This worked for me hope it does for all.
Navin Sir, It is wrong library wrong used in the video that is pip install mysql-connector. The correct library is pip3 install mysql-connector-python to connect mysql with python and pycharm.
*I AM GETTING THE ERROR WHICH IS SPECIFIED IN THE TIMING **3:50** EVEN AFTER INSTALLING THE PYTHON CONNECTOR. WHAT IS THE PROBLEM ?PLEASE HELP ME AS SOON AS POSSIBLE PLEASE ITS URGENT.*
Bro one question which is most used and has future ... Python + MySQL or Python + MongoDB Or which combination gives good demand while shifting to another company
It totally depends on the scenario. If you are building an application for buisness use whose database can be structured in rows and columns then go for SQL databases like MySQL, POSTGRESQL etc. But where as if you are building an application whose databse has complex tree like structure like social media apps whose comments section is hard to build with SQL databases we come up with NoSQL databases such as MongoDb.
One correction, if you are watching in 2022 @04:00 you might be getting "Authentication plugin 'caching_sha2_password' is not supported" error.
Just uninstall mysql-connector & install mysql-connector-python.
How to uninstall it...
@@sunitatanwar7866 pip uninstall mysql-connecter
Thank you very much .
You sir are a legend. Works even in 2024
Thanku soo much bhai
I watched whole of these Python playlist and learnt the Python for FREE. Thanks a lot. Appreciate your teaching and work :-)
Probably the best explanation of how to connect to MySQL ever !!
same prob me also.....
I learnt python by seeing all your videos . Hats off to you sir 👏
Who all are watching 1 day before Practical exam
Mee
Meee😢
Couple of years ago I used to be your channel fan for Java. However, now you're rocking in python. You're definitely a master of all trades. Kudos you talent
Pychram or Sublime error:
if you have mysql 8.0.15 version , then you need to have mysql connector-8.0.15
Open Pycharm go to File->Settings-> Preferences->Project->Python Interpreter inside Pycharm, and search for mysql-connector-python and select version as 8.0.15 from dropdown list and click in install.
for Sublime:
go to command prompt, uninstall any old mysql connector
pip3 uninstall mysql-connector
C:\Users\Sanju>pip3 uninstall mysql-connector
pip3 install mysql-connector-python
C:\Users\Sanju>pip3 uninstall mysql-connector-python
Thank you very much! I had the problem ' Authentication plugin 'caching_sha2_password' is not supported' and this fixed it for me
really you are alien......helped me a lot everytime I search something I am ending up with your solution....its really working out for me....
Visual Studio is Baap! 🔥
Using it since i was 13 years old
how do
you connect with vs
tu kon hota hai be baap banane wala.
@@abhinavthapliyal8322 hmm.. but even i use it
Well explained thank you very much Sir
Thanks mate. What is the difference/purpose between using 'mysql-connector' vs 'sqlalchemy' ?
Navin, can't find the pip3 installation vdo which you where mentioning.
I had the same situation, the way I solved was to go where python is located, in my case c:\users\myname\python\pip3 install mysql-connector, I hope this helps
Those who have facing connection problem need to install two pckg
1st mysql-connector
2nd mysql-connector-python
*** if you are using workbench 8.0 CE
It worked for me. Thanks for the solution
Thanks a lot it helped me .I am trying from so many days I had seen lot of video but never work. But this video clear my problem.
Inserting values into tables , after the line mycursor
insert = ' ' ' INSERT INTO STUDENT VALUES ( 106 , ' PAVAN ' ) ' ' '
mycursor.execute( insert)
if your cmd cant find pip or pip3 just go to python's official website and download the latest version of python and then try pip on your cmd , worked for me
Hi, Firstly I want to thank you for this useful video series. Could you please release the Oracle/Mango database connection and basic queries. A lot of people use these databases. Thank you so much.
as of november 6, 2019, line 3 from code at 3:39 won't work.
instead do
mydb = mysql.connector.connect(user='navin', password='1234',
host='localhost', auth_plugin='mysql_native_password')
and that works. you should also have 'mysql-connector-python' and 'mysql-connector' installed.
are mysql-connector-python and mysql-connector both different from each other...?
I am having this type of error
"Authentication plugin '{0}' is not supported".format(plugin_name))
NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
Hey Navin, when I start working and earning a salary I'm donating I promise. I mean I am totally straight but I have never loved another man this much.
XD
your videos are really helpful to me.. thank you very much
I recommend people to first uninstall mysql-connector and than install mysql-connector-python as there should clash between both of than while importing library
If anybody gets a dumb error try adding use_pure = True:
mydb = mysql.connector.connect(host="localhost", user = "root", passwd = "password", use_pure = True)
Best video on you tube ,Your Explanation is very good
child can understand your tutorials easily
Super Explanation Sir👌👉.
hello im korean student i had saw this video so i want to talk you very appreciate.
U mean `thank' ?
@@nothingspecial7163 yes!!! hahah
want to start by thanking you sincerely for all the effort you've put in-you're truly the best. After following your Python series, I feel confident that I've grasped all the key concepts. However, I'm wondering if you've covered Python scripting and Robot Framework somewhere, as I couldn't find any content on that in your channel. Could you please let me know if you've explained those topics? Thank you!
For those students whose output isn't showing properly first install the correct packages properly. Download Pycharm community edition first then got to File then settings. Over there under python interpreter click on the plus icon on top and search mysql-connector-python. Download it and your good to go.!!!
And showing, module 'mysql.connector' has no attribute 'connect'
Any solutions.?
I'm a new user of ubuntu for installation of MySQL taken the whole day. Atlast it worked.
5:47 I got no result when I ran the code after following all the steps. I tried to reinstall the MYSQL server with the SHA password authentication option instead of the legacy authentication. The code now returns the desired output.
Really nice sir. Content is very good and to the point.
description box link didn't help to solve pip3 not found error.Please help us.Thanks in advance.
hey uma I was also getting the same problem.
To solve it just see the video of setting up the path video from this playlist and then try cmd prompt pip3/3.7(depends upon the version you are using) install MySQL-connector
please use this command on cmd ""pip install mysql-connector-python"" this will solve the issue.thanks
Thanking You for kind this Stuff and Encouragement...this is really best to everyone.. You are a real master, without skip any , and u thought as everything which is related to Python...
i am learning and understanding better than my whole month classes thanku sir
Wow, you are an angel! Thanks for the teaching.
please make a video on python with mysql using xampp
If you guys getting error like me go to the folder where Python is installed press shift+RMB and click open PowerShell here and write the code below :
C:\Users\thede\AppData\Local\Programs\Python\Python38> py -m pip install mysql-connector
this guy is the best i wish i had found this channel earlier
I always watch your video sir u r very good teacher 😊😊
Great job Navin. Your series have been really helpful. I've learnt a lot. I'd appreciate if you can do also on Big data using python. Looking forward to it so much.
I don't know anything about MySQL, so I got the message. I need to learn it, first I will finish this playlist and learning MySQL will be my next endeavour.
A BIG thank you to the whole team behind this effort.
Can you plz share from where you are learning SQL?
Superb sir Thank you so much without your video it is not possible to connect python with mysql
What is better for production builds? and large scale applications. Do we use ORM like SQLAlchemy? or just a connector. If performance is the metrics
mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on 'localhost:3306' ( No connection could be made because the target machine actively refused it)
if you are getting this error maybe you changed port number , don't uninstall that just change back port number
same error here
btw wht is port number, How to chnge??
Clear steps to establish connection and try initial queries. Thanks Navin!
When I import the mysql.connector it raises ModuleNotFoundError error?
After install mysql.connector show error into Pycharm such as "ModuleNotFoundError: No module named 'mysql.connector'". Now pl give suggestion, what to do ?
Your all series videos are awesome and brilliantly explained. Can you also please make tutorial on ' tkinter GUI ' ?
Sir pls explain database connectivity with pycharm also....I m using pycharm from ur starting video
mysql module not installed error solution(pycharm)
file > settings > project > yourproject >project interpreter > click plus button> search for mysql-connector > install
Error visual studio ++ something what is the solution for this
@badar munir
error is being occured in my pc even after doing the above thing
When I try to connect python with mysql in sublime I get an error
Error : Authentication plugin 'caching_sha2_password' is not supported
Hi, watch his previous video and follow the steps of installation. I to had this same error and it got fixed by following his way.
u must set a path........ "\cd"....... try this b4 install it might work then.
Very useful and helpful video to get started with python and MySQL !!!
in sublime the message Can't connect to MySQL server on 'localhost:3306' (10061 No connection could be made because the target machine actively refused it) also appears.
Same problem
GOD sir ji : i watched both the videos , its much helpful
The video was very nice. All it compromises of useful informations.
Sir , I have installed MySQL and had run the code in sublime editor ,but I have got error (MySQL module donot found) but when I run in python shell I got answer.plss ,help me sir
same.
This is really helpful, could you please explain about posting data from a html for to the database for user registration and login using python.
Sir, the best guide you are, simple and to the point
Sir, for Python, we need to do pip3 install mysql-connector-python
@@amoghranganath4155 that is for installation in PyCharm , not for Sublime text
Thank you so much sir.. I have run this code in VS code and it is still working
Shall i write this program in pycharm please let me know. I have tried to write in pycharm but getting an error as no module named 'mysql '
Thank you so much! Simple and to the point! Worked like a charm!
Make a video on beautifulsoup/webscrapping. Please.
Is the installation of my-sql-connector one time or everytime you have will connect my-sql to python?
one time only
but you need to import module in python while using mysql
how to use sublime here do i need to install it first? if so, from where please guide me sir...
thanks a ton for this series...lots of respect for you and your work...
Use the command mysql-connector-python rather than using mysql-connector while using the pip install....(if ypu are using the latest version of MySQL its 8.0.7 i guess)
Regards:- Tanishq:)
Den how to import the mysql module in code
@@vanithas2701 import myql-connector
Actually am getting a module not found error while running the python code on command prompt , so can u plz let me know y bcz i have already installed the connector but still i am unable to run d Python code
Thank you so much sir ,It was helped me a lot. ✨☺️Keep going.
while putting in the "host" variable you put localhost there but if you were hosting this database on a website what were you supposed to put? The websites link or the ip address of that website?
Awesome and very easy to connect, only I struggle while installing mysql connector
sir, I am a complete beginner in python. I am learning python from it's word meaning, from you. But this video creating a fear that I need some programming background to watch upcoming playlist videos. Is it true sir. If yes please help me .....sir
didnt found link for that pip is not working. as you mention in video at 1:11
Which software are you using to record
the videoo to get the dask top screen and your self at the same time. Please reply sir
sir, I have watched ur video, and got stuck with error, help me solving this
"Authentication plugin '{0}' is not supported".format(plugin_name))
mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
try installing pip3 install mysql-connector-python
@@balrajei Thanks
Download mysql-connector-python
I was getting the same error and resolve it by downloading the above connector
It would be really useful...Recently i have done some project for which I needed a video like this very badly.. I've had to watch so many videos to complete it..Nobody is as good as u
can we use Xampp myphpadmin instead of MySQL workstation?
Hello, I have made a face recognition model using open CV. I am accessing the trained data from my computer itself (local server). Now I wanted to extract my data from Cloud insted of local server. What should be my approach and how should I modify my code.
Please guide me with this.
Thanks for uploading such an informative video
txns a lot finally i got it and i subscribed tooo😎😎😎😎
hello
one question
which database i should use for python for create web application??
a database with best speed an performance !!
i use windows 10 .. and IDE Visual studio Code
i want a database for python Which is not necessary to change it later to another database
Great learning... It was great learning experience.
How do I send the output parameter for a stored procedure from python? It keeps breaking saying I sent more args if I send an additional 0 or '@out' and if I don't send it, it asks for it.
Great video and platform to learn quick and easily.
Your pythoooon series is epic😊
Very informative. Thank You!
Thank You this helped in my IP project
Solution to Access Denied Error
Run the same command which he ran initially but run cmd as an administrator. This can be done by right clicking on cmd and selecting run as administrator. This worked for me hope it does for all.
no video for pip3 error. please help!!
Thank YOu
Did u got solution ? is pip3 working? if so please help me.
set the path thats it
thankyou very very very muchhh sir i was too much confused with this concept
Navin Sir, It is wrong library wrong used in the video that is pip install mysql-connector.
The correct library is pip3 install mysql-connector-python to connect mysql with python and pycharm.
Sublime text 3 is love ❤️❤️
I do all coding whether it be C, python, css etc all in one app... ✌️
Help to fix pip3 install
Its giving syntax error
I am getting " Python was not found but can be installed from the Microsoft store:" at the output of Sublime Text....can anyone please help me..
so will the procedure be same in case of connecting with a live database server?
You are great sir
I'm very glad to see your video...and keep giving such kind of knowledge full of our study.......stay happy and blessed
*I AM GETTING THE ERROR WHICH IS SPECIFIED IN THE TIMING **3:50** EVEN AFTER INSTALLING THE PYTHON CONNECTOR. WHAT IS THE PROBLEM ?PLEASE HELP ME AS SOON AS POSSIBLE PLEASE ITS URGENT.*
This is great. I hope you the similar process for IBM DB2. If you have that video can you
Please share 😊
Bro one question which is most used and has future ... Python + MySQL or Python + MongoDB
Or which combination gives good demand while shifting to another company
It totally depends on the scenario. If you are building an application for buisness use whose database can be structured in rows and columns then go for SQL databases like MySQL, POSTGRESQL etc. But where as if you are building an application whose databse has complex tree like structure like social media apps whose comments section is hard to build with SQL databases we come up with NoSQL databases such as MongoDb.
I didn't find the pip connection error video in description box. Can u let me know where it is exactly?
sir thanku
very very much😍😘😘😘😘😘😘
i have installed the connector still in pycharm its showing no package with tha name
type this *"python -m pip install mysql-connector-python"* if you still have problem
I too get that 🥺
Please help !