We can choose the any database as per our best and convenient of our application.
Python Database API supports a wide range of database servers such as −
Python Database Interfaces and APIs. You must download a separate DB API module for each database you need to access.
Following the steps given bellow to connect a python application to our database.
The time of creating connections between the MySql database and the python application, there is a method called connect() method is used.
connect() methods is accessed from mysql.connector module is used.
To make the connection we must pass the database detailts such as HostName, Username, and database password in the method call.
Hence, the method will returns the connection object or status.
<mysql.connector.connection.MySQLConnection object ar 0x016645F0>
In the next tutorial we will create the Database and Tabel.