Question

name the module used to establish a database connection with a python
program.​

Answer 1

Answer:

To create a connection between the MySQL database and the python application, the connect() method of mysql.connector module is used.

Pass the database details like HostName, username, and the database password in the method call. The method returns the connection object.

Answer 2

Answer: mysql.connector

Explanation: this module perfectly works for Python-MySQL connectivity..

you can use it is

import mysql.connector as mysql

con=mysql.connect(host='localhost', user='root', password='root', database='<databasename>')

cur=con.cursor()     # cursor object

cur.execute("<any MySQL query>")