Python MySQL Tutorial - Setup & Basic Queries (w/ MySQL Connector)

Learn how to use MySQL and SQL with python. In this series I will show you how to use the python mysql connector to create tables, insert data and work with a MySQL database.

MySQL is a relational database management system. It is a great tool to learn how to use and will allow you to demonstrate your experience with RDBMS to future employers. (Employers usually require you know SQL!!)

Links:

◾◾◾◾◾
💻 Enroll in The Fundamentals of Programming w/ Python

◾◾◾◾◾◾

⚡ Please leave a LIKE and SUBSCRIBE for more content! ⚡

Tags:
- Tech With Tim
- Python Tutorials
- Python MySQL
- MySQL Tutorial Python

#Python #MySQL #SQL

[TechWithTim]

Let me know what you want from this series!

[virgil]

In case you get an error along the lines of:
"line 191, in get_auth_plugin
"Authentication plugin '{0}' is not Authentication plugin 'caching_sha2_password' is not supported" it's because you don't have the right version of the python connector. you can get the right version with the following command
*pip install MySQL-connector-python*

[elliamorse]

This was a lovely introduction to your channel and I'm looking forward to watching more of your videos and completing this series on MySQL and Python!

[desislavaandreeva]

I use MySQL in my daily work and combining with python as extra knowledge outside of the office will definitely help me jumping in a better job! Thank you Tim, you are a wizard!

[alexandermread]

Hey I got the error Authentication plugin 'caching_sha2_password' is not supported' and it was because I installed 'mysql-connector' using pip instead of 'mysql-connector-python'. Just letting anybody know in case someone made the same mistake

[erack]

Awesome, awesome, awesome. Tim. I recently got into Python3 in the last month, and I'm in love. Your series on Selenium has help tons for my web automation program i'm trying to create. I'm looking forward to incorporating the MySQL database to this program for data management. Love your videos!

Much love,

Nick

[vudhanthineeraja]

This series really helped me out! Got to submit my project tomorrow (i.e. today it is currently 1:30 am where I'm rn lol), thanks to you Tim, I can sleep now! I just can't thank you enough! Also after seeing this video I've made up my mind to take up the machine learning course you teach on FreeCodeCamp. Once again thank you so much! <3

[foxglvz]

Damn looks like a awesome series is going on here! Greetings from FR thanks a lot, you rock man!! ♥

[DuniaDY]

Excellent stuff, high quality content in your videos! Thanks for putting in all the good work, Tim.

[adri]

This is really need! Thanks Tim! You are doing an awesome job! I think that explaining how SQL works in more depth, how to code in SQL, how to handle data (retrieve it from the server and send it to the server) using python...Those would be good ideas. Also, could you go more deep explaining how the local servers work and how can we create an online server? Thanks again man!!!

[trevordontstalkme]

This is a fucking gold mine, this guy explains shit with just enough depth to invoke thought but simple enough to retain. Thank you!

[shashwatm]

I HAVE SEARCHED FOR THOUSANDS OF VIDEOS...AND I DIDNT UNDERSTAND....YOURS HELPED ME A LOT....THANKS TIM!

[kasyapdharanikota]

thank you ; installed the whole setup without any problems after following your instructions

[BurmeseBlueRose]

Лучшее видео про установку mySQL! Спасибо!
The best video about installing mySQL! Thanks!

[JollyBeJolly]

Thank you Tim. Watched countless other tutorials and they are making download this and that and making re download this and that.

[Shadowex]

For anyone having the error:
Authentication plugin 'caching_sha2_password' is not supported"

Instead of running:
pip install mysql-connector

Run:
pip install mysql-connnector-python

[jaimecrawford]

Thanks! This got me going with the mysql connector for python after a few failed attempts.

[metalflames]

Thank you!! Gave me exactly what I needed to get my first connection and test done!

[ImGeneralJAckson]

you are explaining this much more clearly and concisely than my grad professor. Thank you!

[datofficial]

this was exactly what i was looking for and it was the first video i clicked on Tim the Top GUY EVERYTIME