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.