Skip to content
Related Articles

Related Articles

Create Database in MariaDB using PyMySQL in Python
  • Last Updated : 14 Oct, 2020

MariaDB is an open source Database Management System and its predecessor to MySQL. The pymysql client can be used to interact with MariaDB similar to that of MySQL using Python.

In this article we will look into the process of creating a database using pymysql. To create a database use the below syntax:

Syntax:CREATE DATABASE databaseName;

Example :

In this example we will be using the pymysql client to create a database named “GFG”:

Python






# import the mysql client for python
  
import pymysql
    
# Create a connection object
# IP address of the MySQL database server
Host = "localhost" 
  
# User name of the database server
User = "user"       
  
# Password for the database user
Password = ""           
  
conn  = pymysql.connect(host=Host, user=User, password=Password)
  
# Create a cursor object
cur  = conn.cursor()
  
# creating database 
cur.execute("CREATE DATABASE GFG"
  
cur.execute("SHOW DATABASES")
databaseList = cur.fetchall()
  
for database in databaseList:
  print(database)
    
conn.close()

Output :

creating database in mariadb

The above program illustrates the creation of MariaDB database “GFG”  in which host-name is ‘localhost‘, the username is ‘user’ and password is ‘your password’.

Let’s suppose we want to create a table in the database, then we need to connect to a database. Below is a program to create a table in the GFG database which was created in the above program.

Example :

Python3




import pymysql
  
conn = pymysql.connect('localhost','user','password','GFG')
cur = conn.cursor()
cur.execute("DROP TABLE IF EXISTS PRODUCT"
query = """CREATE TABLE PRODUCT ( 
         PRODUCT_ID  CHAR(20) NOT NULL, 
         price  int(10), 
         PRODUCT_TYPE VARCHAR(64) ) """
  
# To execute the SQL query
cur.execute(query)   
  
# To commit the changes
conn.commit()         
conn.close()

Output :

adding tables in mariadbadding tables in mariadb

Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.

To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course.

My Personal Notes arrow_drop_up
Recommended Articles
Page :