How to create MySql database using Python

Question

Hi Guys,

I am trying to create a MySql database using Python. I have installed MySql connector to my system. How can I do that?

Answer 1

Hi@akhtar,

You need to use MySQL connector in your python code. I have attached one example below for your reference.

import mysql.connector
mydb = mysql.connector.connect(
  host="localhost",
  user="myusername",
  password="mypassword"
)
mycursor = mydb.cursor()
mycursor.execute("CREATE DATABASE mydatabase")