Python Mysql Connector Example

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

Program:

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

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

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

connect_var.close()
                /* ............... END ............... */
        

Notes:

  • 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.
Similar Programs Chapter Last Updated
Python Tuples Example Python 19-11-2021
Python Iterator Example Python 12-11-2021
Python Lambda Functions Python 11-11-2021
Integer To String In Python Python 22-10-2021
Python Datetime Format Python 21-10-2021
Range Function In Python | Python range () Python 11-10-2021
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

1