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
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.
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
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!
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 recommend people to first uninstall mysql-connector and than install mysql-connector-python as there should clash between both of than while importing library
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.
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.!!!
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
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.
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...
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.
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
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
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
Hello it's really heplfuf. Could you please make a video one reading an excel file using python and then store the values in a tabular format in database. Please reply it's really important to me
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:)
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.
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?
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
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
thank you sir. the video quality was excellent , and you are having very excellent teaching skills as well as programming skills, and that's why we love navin reddy .
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 👏
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
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
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
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....
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!
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
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
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.
Who all are watching 1 day before Practical exam
Inserting values into tables , after the line mycursor
insert = ' ' ' INSERT INTO STUDENT VALUES ( 106 , ' PAVAN ' ) ' ' '
mycursor.execute( insert)
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
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
Thanks mate. What is the difference/purpose between using 'mysql-connector' vs 'sqlalchemy' ?
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.?
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
I'm a new user of ubuntu for installation of MySQL taken the whole day. Atlast it worked.
Well explained thank you very much Sir
If anybody gets a dumb error try adding use_pure = True:
mydb = mysql.connector.connect(host="localhost", user = "root", passwd = "password", use_pure = True)
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
hello im korean student i had saw this video so i want to talk you very appreciate.
U mean `thank' ?
@@nothingspecial7163 yes!!! hahah
Super Explanation Sir👌👉.
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.
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...
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?
Best video on you tube ,Your Explanation is very good
child can understand your tutorials easily
please make a video on python with mysql using xampp
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
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
Wow, you are an angel! Thanks for the teaching.
Clear steps to establish connection and try initial queries. Thanks Navin!
Really nice sir. Content is very good and to the point.
GOD sir ji : i watched both the videos , its much helpful
Thank you so much sir.. I have run this code in VS code and it is still working
this guy is the best i wish i had found this channel earlier
i am learning and understanding better than my whole month classes thanku sir
Awesome and very easy to connect, only I struggle while installing mysql connector
Superb sir Thank you so much without your video it is not possible to connect python with mysql
Your all series videos are awesome and brilliantly explained. Can you also please make tutorial on ' tkinter GUI ' ?
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
Very useful and helpful video to get started with python and MySQL !!!
Sir pls explain database connectivity with pycharm also....I m using pycharm from ur starting video
this video was very successful for me
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
The video was very nice. All it compromises of useful informations.
Sublime text 3 is love ❤️❤️
I do all coding whether it be C, python, css etc all in one app... ✌️
thank you for this video....please do video for oracle 19c with python .....if you have time
Thank you so much! Simple and to the point! Worked like a charm!
Great explanation
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
You are great sir
Make a video on beautifulsoup/webscrapping. Please.
Thanks for uploading such an informative video
I always watch your video sir u r very good teacher 😊😊
Hello it's really heplfuf.
Could you please make a video one reading an excel file using python and then store the values in a tabular format in database.
Please reply it's really important to me
Sir ,can we use Thonny IDE
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...
Very informative. Thank You!
Great learning... It was great learning experience.
Hello Sir. Great Video. Can you please make video on connecting MySQL with colab. I am facing challenges.
I'm very glad to see your video...and keep giving such kind of knowledge full of our study.......stay happy and blessed
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
Thank you great developer
Oswaal book scan kiya to idar redirect kiya wow🤩🤩
so will the procedure be same in case of connecting with a live database server?
Nice video. Thanks. Please show the same for oracle also.
This is great. I hope you the similar process for IBM DB2. If you have that video can you
Please share 😊
Thanks for the help.
Great video and platform to learn quick and easily.
wow well explained
You're good and I like it!!
Gr8 video helped alot for my practical
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 plz do database connection in pycharm
My Favorite HTML And CSS
thankyou very very very muchhh sir i was too much confused with this concept
Master navin reddy, Can you upload a video abot Django with Oracle DB
Thanks for the video
Thank you so much sir ,It was helped me a lot. ✨☺️Keep going.
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.
excellent information
Sir please make videos on turtle and tkinter python...
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
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?
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
Awesome sir you have unbelievable power
so nice of you bro!
sir can you plese make video how to connect oracle sql plus to pycharm......................................
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
thank you so much sir
This is the best python tutorial I must say ...thank you sir
Just fantastic..
navin sir,may know which notes or book should i refer for python from basics to advanced
thank you sir. the video quality was excellent , and you are having very excellent teaching skills as well as programming skills, and that's why we love navin reddy .
thankyou sir
can we use Xampp myphpadmin instead of MySQL workstation?