Python Mysql Connector Example

Chapter: Python Last Updated: 21-11-2020 05:25:56 UTC


            /* ............... START ............... */
import mysql.connector
print("Opening mysql connection")

connect_var = mysql.connector.connect(user='root', password='pwd', 
host='', database='userlist')

#if you running locally you can use without host also
connect_var = mysql.connector.connect(user='root', password='pwd',

                /* ............... END ............... */


  • First step to install mysql python connector, for that we have to install the same using pip (package manager for Python)
  • Below command will install pip in windows
  • pip install -U pip
  • For installing mysqlclient in your machine please type below command
  • pip install mysqlclient
  • If you want to install mysql-connector-python in system please follow the below command
  • pip install mysql-connector-python
  • Python mysql connector is used to connect python to mysql database.
  • The connect() constructor creates a connection to the MySQL server.
  • The connect() constructor is used in mysql to return MySQLConnection object.


Python Mysql Connector Example, How to connect python to mysql, mysql connector for python

Similar Programs Chapter Last Updated
Python Desktop Notification Popup In Linux Python 10-07-2021
Python JSON Parser Example | How To Parse JSON In Python Python 25-06-2021
Python PIP | How To Install Packages In Python Python 16-06-2021
How To Access Python Dictionary Python 14-06-2021
Dictionary In Python Examples Python 10-06-2021
Shortest Path Algorithm In Python Python 23-02-2021
Merge Sort In Python Python 01-12-2020
Kruskal Algorithm In Python Python 28-11-2020
Add To Set Python Python 05-10-2018
Set In Python Python 05-10-2018
List In Python Python 29-09-2018
Integer To String Python Python 29-09-2018
Python Variables Python 21-09-2018
Python String Contains Python 15-09-2018
String In Python Python 22-09-2018
Python Switch Statement Python 20-09-2018
Python Function Example Python 14-09-2018
Python If Statement Python 14-09-2018
Area Of Triangle In Python Python 14-09-2018
Python Square Root Python 22-09-2018
Add Two Numbers In Python Python 13-09-2018
Python Comments Python 22-09-2018
Python Hello World Python 14-09-2018