#73 Python Database Connection | MySQL
HTML-код
- Опубликовано: 3 ноя 2018
- Check out our courses:
Spring and Microservices Weekend Live Batch : bit.ly/spring-live-weekend
Coupon: TELUSKO10 (10% Discount)
Master Java Spring Development : bit.ly/java-spring-cloud
For More Queries WhatsApp or Call on : +919008963671
website : courses.telusko.com/
Instagram : / navinreddyofficial
Linkedin : / navinreddy20
TELUSKO Android App : bit.ly/TeluskoApp
Discord : / discord
Python MySql Example
MySql Workbench and MySql Connector video: • #72 MySQL Workbench Se...
Python Tutorial to learn Python programming with examples
Complete Python Tutorial for Beginners Playlist : • #1 Python Tutorial for...
Python Tutorial in Hindi : • #1 Python Tutorial | I...
Github :- github.com/navinreddy20/Python-
Java and Spring Framework For beginners with Spring Boot : - bit.ly/3LDMj8D
Java Tutorial for Beginners (2023) :- bit.ly/3yARVbN
Subscribe to our other channel:
Navin Reddy : / @navinreddy
Telusko Hindi :
/ @teluskohindi
Editing Monitors :
amzn.to/2RfKWgL
amzn.to/2Q665JW
amzn.to/2OUP21a.
Donation:
PayPal Id : navinreddy20
Patreon : navinreddy20
www.telusko.com/contactus Наука
I watched whole of these Python playlist and learnt the Python for FREE. Thanks a lot. Appreciate your teaching and work :-)
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
Thanks mate. What is the difference/purpose between using 'mysql-connector' vs 'sqlalchemy' ?
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.
Well explained thank you very much Sir
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.
Really nice sir. Content is very good and to the point.
Probably the best explanation of how to connect to MySQL ever !!
same prob me also.....
Thank you so much! Simple and to the point! Worked like a charm!
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...
Clear steps to establish connection and try initial queries. Thanks Navin!
Your all series videos are awesome and brilliantly explained. Can you also please make tutorial on ' tkinter GUI ' ?
Best video on you tube ,Your Explanation is very good
child can understand your tutorials easily
Thanks Navin for the simple and informative video.
i am learning and understanding better than my whole month classes thanku sir
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
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
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....
You really made it simple, thanks a tonn
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 useful and helpful video to get started with python and MySQL !!!
Hi Navin,
What is the procedure to connect with Windows RDP machines through python?
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.
Superb sir Thank you so much without your video it is not possible to connect python with mysql
your videos are really helpful to me.. thank you very much
navin sir,may know which notes or book should i refer for python from basics to advanced
this guy is the best i wish i had found this channel earlier
can I get column names also be read in python bcz i need to use them for my code as. well
I always watch your video sir u r very good teacher 😊😊
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.
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
can we use Xampp myphpadmin instead of MySQL workstation?
Who all are watching 1 day before Practical exam
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?
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?
so will the procedure be same in case of connecting with a live database server?
Super Explanation Sir👌👉.
Thank you so much sir.. I have run this code in VS code and it is still working
Wow, you are an angel! Thanks for the teaching.
When I import the mysql.connector it raises ModuleNotFoundError error?
Tq so much sir for continuing this series
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 '
GOD sir ji : i watched both the videos , its much helpful
You are great sir
Great video and platform to learn quick and easily.
Gr8 video helped alot for my practical
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.
Very informative. Thank You!
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
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
The video was very nice. All it compromises of useful informations.
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.
Hi Navin, Im your great Fan. Thanks for your tutorials.. :)
Can you please help me write a sql statement in python where i have a
table with 2 columns SrNo (Identity Column) WtName (NVARCHAR).
my statement : sql2='''Insert into CaseID(WtName)
values('%s')'''%(Sub_Activity)
does not work.. no error but does not insert a row in sql server
database. Thanks in advance..
You made sooooo easy.... thank you sir
Thank you so much sir ,It was helped me a lot. ✨☺️Keep going.
After install mysql.connector show error into Pycharm such as "ModuleNotFoundError: No module named 'mysql.connector'". Now pl give suggestion, what to do ?
Awesome and very easy to connect, only I struggle while installing mysql connector
thank you sir . It is really wonderful...
Sir But how can we insert values by using sublime into MySQL workbench i getting an error please make your vedio it's so helpful to us
Great learning... It was great learning experience.
Awesome sir you have unbelievable power
so nice of you bro!
Thanks for uploading such an informative video
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
please make a video on python with mysql using xampp
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
This is good for me
this video was very successful for me
my sublime is showing an error for fetchall and fetchone method why?
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
thankyou very very very muchhh sir i was too much confused with this concept
txns a lot finally i got it and i subscribed tooo😎😎😎😎
Help to fix pip3 install
Its giving syntax error
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
You're good and I like it!!
I'm a new user of ubuntu for installation of MySQL taken the whole day. Atlast it worked.
Excellent sir
Can you do this in Aws RDS using Boto Module
Inserting values into tables , after the line mycursor
insert = ' ' ' INSERT INTO STUDENT VALUES ( 106 , ' PAVAN ' ) ' ' '
mycursor.execute( insert)
This is great. I hope you the similar process for IBM DB2. If you have that video can you
Please share 😊
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
Hello sir , I have written some code in python in IDLE(and saved it has .py) then how to connect that code to MySQL database run it there .Sir just tell me the method to connect it......pls
Great explanation
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
Great man👨
can you make it inside the class ? i can connect to that but when i put it on class i cant get it to work. thanks
Thank you great developer
Thanks for the video
Naveen Sir, I did a custom installation of MySQL in which I chose MySQL Shell and Server but forgot to install Workbench and Connector. Could you please tell me how to install them without uninstalling and reinstalling the server and shell of MySQL. 👼
Make a video on beautifulsoup/webscrapping. Please.
"pip3" is not working in my system. Sir can you please tell how to make it work or any alternative method.....
Thanks for the help.
What does heavy and lightweight mean when describing IDEs?
what to do if i want to implement python app with database to the consumer?
how do i combine database and python to 1 file so i can put it inside the rar?
Hi sir, how do we understand business problems in python?
wow well explained
Guys I installed Microsoft sql studio. Does it work for sublime editor? If yes how to import that sql with command in sublime?
Thanks sir navin ❤
Hi. I have a problem in sending the user input to the database (mysql) in python GUI. What should I do? Please help.
Sir pls explain database connectivity with pycharm also....I m using pycharm from ur starting video