Create Connection

Let’s start the creating connection with database

Demo.py

import mysql.connector
mycon=mysql.connector.connect(
host="localhost",
user="root",
passwd="1234")
print(mycon)

Output

C:\Users\laptop>python demo.py

Create a Database

Create database we have to fire Create database statement.

import mysql.connector
mycon=mysql.connector.connect(
host="localhost",
user="root",
passwd="1234")
mycur=mycon.cursor()
mycur.execute('CREATE DATABASE college')

Above program code was executed with no error. You have successfully database created

Checked Database Exists ?

import mysql.connector
mycon=mysql.connector.connect(
host="localhost",
user="root",
passwd="1234")
mycur=mycon.cursor()
mycur.execute("SHOW DATABASES")
for x in mycur:
 print(x)

Output

C:\Users\laptop>python demo.py
('information_scheme',)
('college',)
('performance_schema',)
('sys',)

After creating the database you can access the database by using the ‘database’ keyword.

import mysql.connector
mycon=mysql.connector.connect(
host="localhost",
user="root",
passwd="1234"
database="college"
)

Output

C:\Users\laptop>python demo.py
Subscribe Now