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.

Tags

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

Similar Programs Chapter Last Updated
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