Database Connection

In Python, the database connection is a communication link between a Python program and a database system. Using this connection, Python can execute several operations, including SQL queries, fetch results, and perform database operations. Here, we will discuss the steps to connect the python application to the database.

There are the following steps to connect a python application to our database.

1. Import mysql.connector module
2. Create the connection object.
3. Create the cursor object
4. Execute the query

Creating the connection

In order 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.

Syntax for Creating the Database Connection

The syntax to use the connect() is given below.

Python Example for Creating the Database Connection

Let's consider the following example to demonstrate how to create the database connection.

Output:

<mysql.connector.connection.MySQLConnection object at 0x7fb142edd780> 

Here, we must notice that we can specify the database name in the connect() method if we want to connect to a specific database.

Example

Output:

<mysql.connector.connection.MySQLConnection object at 0x7ff64aa3d7b8> 

Creating a cursor object

The cursor object can be defined as an abstraction specified in the Python DB-API 2.0. It facilitates us to have multiple separate working environments through the same connection to the database. We can create the cursor object by calling the 'cursor' function of the connection object. The cursor object is an important aspect of executing queries to the databases.

Syntax for Creating Cursor Object

The syntax to create the cursor object is given below.

Python Example for Creating Curson Object

Let's consider the following example to demonstrate how to create the cursor object.

Output:

<mysql.connector.connection.MySQLConnection object at 0x7faa17a15748> 
MySQLCursor: (Nothing executed yet)