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