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