Skip to content
Related Articles

Related Articles

Connect MySQL database using MySQL-Connector Python

View Discussion
Improve Article
Save Article
  • Difficulty Level : Easy
  • Last Updated : 13 Sep, 2021
View Discussion
Improve Article
Save Article

While working with Python we need to work with databases, they may be of different types like MySQL, SQLite, NoSQL, etc. In this article, we will be looking forward to how to connect MySQL databases using MySQL Connector/Python.
MySQL Connector module of Python is used to connect MySQL databases with the Python programs, it does that using the Python Database API Specification v2.0 (PEP 249). It uses the Python standard library and has no dependencies.
 

Connecting to the Database

In the following example we will be connecting to MySQL database using connect()
Example:
 

Python3




# Python program to connect
# to mysql database
 
 
import mysql.connector
 
 
# Connecting from the server
conn = mysql.connector.connect(user = 'username',
                               host = 'localhost',
                              database = 'database_name')
 
print(conn)
 
# Disconnecting from the server
conn.close()


Output:
 

python-mysql-connect-1

Also for the same, we can use connection.MySQLConnection() class instead of connect():
Example:
 

Python3




# Python program to connect
# to mysql database
 
 
from mysql.connector import connection
 
# Connecting to the server
conn = connection.MySQLConnection(user = 'username',
                              host = 'localhost',
                              database = 'database_name')
 
print(conn)
 
# Disconnecting from the server
conn.close()


Output:
 

python-mysql-connect-2

Another way is to pass the dictionary in the connect() function using ‘**’ operator:
Example:
 

Python3




# Python program to connect
# to mysql database
 
 
from mysql.connector import connection
 
 
dict = {
  'user': 'root',
  'host': 'localhost',
  'database': 'College'
}
 
# Connecting to the server
conn = connection.MySQLConnection(**dict)
 
print(conn)
 
# Disconnecting from the server
conn.close()


Output:
 

python-mysql-connect-3

 


My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!