Interface Python with Mysql – Notes

Real world application needs to manipulate data stored in the database through an application designed, by using any programming language like Python, Java, etc. vIn order to connect to a database from within Python or any other programming language, we need a Driver or Connector library or Interface. vIn case of Python we can use mysql.connector or pymysql library.

What is MySQL Connector/Python

MySQL Connector/Python enables Python programs to access MySQL databases, using an API that is compliant with the Python Database API Specification

Installation MySQL Connector/Python

Use pip to install Connector/Python on most any operating system:

pip install mysql-connector-python

Prerequisite.  :- The Microsoft Visual C++ 2015 Redistributable must be installed on your system.

Leave a Comment

You cannot copy content of this page

Scroll to Top