Python & MySQL - Select Database Example

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

Syntax

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

Sr.No.	Parameter & Description
1	host Optional − The host name running the database server. If not specified, then the default value will be localhost:3306.
2	username Optional − The username accessing the database. If not specified, then the default will be the name of the user that owns the server process.
3	passwd Optional − The password of the user accessing the database. If not specified, then the default will be an empty password.
4	dbName Optional − database name on which query is to be performed.
5	port Optional − the port number to attempt to connect to the MySQL server..
6	socket Optional − socket or named pipe that should be used.

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 database −

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", "TUTORIALS")

# 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 ,)

Python & MySQL - Select Database Example

Syntax

Syntax

Example

Output

友情链接