Python & MySQL - Connect Database Example

Python MySQLdb provides MySQLdb.connect() function to open a database connection. This function takes multiple parameters and returns a connection object to do database operations.

Syntax

db = MySQLdb.connect(host, username, passwd, dbName, port, socket);

There are several other properties as well. Refer MySQLdb for complete reference.

You can disconnect from the MySQL database anytime using another connection object function close().

Syntax

db.close()

Example

Try the following example to connect to a MySQL server −

Copy and paste the following example as mysql_example.py −

#!/usr/bin/python

import MySQLdb

# Open database connection
db = MySQLdb.connect("localhost","root","root@123")

# prepare a cursor object using cursor() method
cursor = db.cursor()

# execute SQL query using execute() method.
cursor.execute("SELECT VERSION()")

# Fetch a single row using fetchone() method.
data = cursor.fetchone()
if data:
   print( Version available:  , data)
else:
   print( Version not retrieved. )

# disconnect from server
db.close()

Output

Execute the mysql_example.py script using python and verify the output.

py mysql_example.py
Version available:  ( 8.0.23 ,)