Question 1 - Past Year - 2 Mark Questions - Chapter 15 - Interface of Python with SQL Database

Given a database Inventory, userid- store manager password – welcometostore123 Write Python code to connect to the above database.

Answer:

import mysql.connector

try:

mydb=mysql.connector.connect("localhost","storemanager","welcometostore123","Inventory")

print("Successfully connectd to the database")

except:

print("Unable to connect to the database")