In this article, we’ll learn how to connect MySQL database with Python using the PyMySQL database driver.

Connect Database with Python

First, we need to install a MySQL database driver called PyMySQL that will help us bridge Python and MySQL.

Now, after installing this package, we can start the connection process by importing it into our Python script.

Create a Python file, let’s say db_connection.py, and write the following code.

This code creates a connection to the MySQL database and then writes an entry in the database table.

First, the package is imported which will help us bridge Python and MySQL using Python code.

Next, we established a connection using pymysql.connect() and passed the required arguments:

• hostname: The location of the MySQL database. We have a MySQL server in the local system hence, we passed "localhost".
• user: Username of the MySQL server. In this case, we passed "root", which is a default name.
• password: Password of the MySQL server.
• database: The name of the database with which you want to connect. In this case, we are connecting to the "consumer" database on the server.
• cursorclass: This decides the format of the result returned by the cursor. In this case, the cursor will return results in a dictionary (DictCursor) format.

Then we created a cursor (sql_connection.cursor()) object that helps in executing SQL queries.

Using cursor.execute(), we executed an SQL query to insert an entry in the consumers table of the consumer database.

Then we saved the changes to the database using sql_connection.commit().

We then executed an SQL query to get all the data from the consumers table in the database.

Using cursor.fetchall(), we fetched all the entries from the table and printed the first result.

Finally, we closed the connection with the database using sql_connection.close().

Now, when we run this code, we’ll get the following result.

That’s all for now.

Keep Coding✌✌.