Python Interface With MySQL

Python MySQL Introduction
Python MySQL Installation
Python MySQL Connection
Check Python MySQL Connections
Python MySQL Create Database
Python MySQL Drop Database
Python MySQL Create Table
Python MySQL Insert (Single Record)
Python MySQL Insert (Multiple Record)
Python MySQL Select
Python MySQL Update
Python MySQL Delete
Call MySQL Stored Procedure
Python MySQL Parameterized Query
Python MySQL Transactions

Python Interface With MySQL 3

Python MySQL Database Connection

In this article, I will demonstrate how to perform MySQL database connectivity in Python using simple 5 steps.

Note: We are using MySQL Connector Python to connect MySQL.

Arguments required to connect MySQL from Python

You need to know the following detail of the MySQL server to perform the connection from Python.

UserName is the username that you use to work with MySQL Server. The default username for the MySQL database is a root

Password is given by the user at the time of installing the MySQL database. If you are using root then you won’t need the password.

Host Name:
Host Name is the server name or Ip address on which MySQL is running. if you are running on localhost, then you can use localhost, or it’s IP, i.e.

Database Name:
Database name to which you want to connect. Here we are using Database named ‘Electronics‘ because we have already created this for our example.

Note: We are using the MySQL Connector Python module to communicate with MySQL Server.


Steps to connect MySQL database in Python using MySQL Connector Python

1. Install MySQL Connector Python using pip.

2. Use the mysql.connector.connect() method of MySQL Connector Python with required parameters to connect MySQL.

3. Use the connection object returned by a connect() method to create a cursor object to perform Database Operations.

4. The cursor.execute() to execute SQL queries from Python.

5. Close the Cursor object using a cursor.close() and MySQL database connection using connection.close() after your work completes.

6. Catch Exception if any that may occur during this process.

Python Example to connect MySQL Database

To connect the MySQL database, you must know the database name you want to connect. Run below query on MySQL console if you have not created any database in MySQL. Otherwise, you can skip the below query.

Create Database in MySQL