#1 Install mysql connector in python | Interface Python with MySQL | Class 12 CBSE Computer Science

Welcome to the Part 1 of the Chapter Interface Python with MySQL .
In this video I have discussed how to install mysql connector to python via command prompt(cmd) in Windows using pip . In order to do deploy applications based on interconnection between python and MySQL Database this connector is required . my-sql-connector serves as a bridge between python and SQL .
The condition for installing mysql connector or any additional python library for that matter is that it is necessary that python should be added to path.

Command to install mysql connector:
pip install mysql-connector-python

If python is not already added to path , you can watch my video on the same by clicking on the link below :

If you haven't watched the other parts of this chapter you can watch by clicking on the links below 👇 :

👉 #2 Introduction to Python MySQL Connectivity

👉 #3 Data Extraction from SQL via Python

👉 #4 Performing SQL Queries via Python | insert , update and delete query

👉 #5 Sending data via. Parameterized Queries

👉 #6 Formatting data via. tabulate library in python

👉 #7 CRUD operations in Python with SQL

Connect on these social media Handles:

#Python #mysqlconnector #PythonMySQL

#Windows7 #Windows8 #Windows10

[UrjaAcademy]

You may purchase the course for Interface Python with SQL with class notes and one to one creator support via the link below :

[jiswahosmani]

Sir can u put video on how to download my sql pls sir

[shanithas]

Sir i can't connect mysql with python. Error showing that could not find a version that satisfies the requirement mysql-connector-python
No matching distribution found for mysql-connector-python.
Pls help sir
Python version: 3.9.1
Mysql 8.0.

[tamilantechtips]

Sir i have python but in CMD it cannot shows it shows error like python --version is not recognized as an internal or external command

[Puh]

sir how many chapter is yet to complete for class 12 with python?

[robertbencze]

you did not demonstrate the results of any SQL query ran in python. you did not show the effects of this in any SQL database.