Find out how to Create a MySQL Database in Python

As a way to create a MySQL database in Python, you first must provoke a connection utilizing the mysql.connector. You’ll be able to find out about learn how to create a connection to MySQL right here.

Find out how to Create a Database in Python

Making a database is straightforward.

First, ensure you have an lively connection to your database, after which set a cursor.

After you have this, subject the execute command to create your database.

import mysql.connector

mydb = mysql.connector.join(
  host = "localhost",
  consumer = "username",
  password = "YoUrPaSsWoRd"
)

mycursor = mydb.cursor()

mycursor.execute("CREATE DATABASE your_database")

Find out how to Verify if a MySQL Database Exists in Python

Utilizing an analogous connection as described above, execute the SHOW DATABASES question.

import mysql.connector

mydb = mysql.connector.join(
  host = "localhost",
  consumer = "username",
  password = "YoUrPaSsWoRd"
)

mycursor = mydb.cursor()

mycursor.execute("SHOW DATABASES")

for x in mycursor:
  print(x)

Find out how to Hook up with a MySQL Database in Python

Now that you understand which database to hook up with, you possibly can specify it instantly to start with.

import mysql.connector

mydb = mysql.connector.join(
  host = "localhost",
  consumer = "username",
  password = "YoUrPaSsWoRd",
  database="your_database"
)