Check sibling questions
Computer Science - Class 12
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")

 

Get Real time Doubt solving from 8pm to 12 am!

Davneet Singh's photo - Co-founder, Teachoo

Made by

Davneet Singh

Davneet Singh has done his B.Tech from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths, Science, Social Science, Physics, Chemistry, Computer Science at Teachoo.