With a purpose to create a MySQL database in Python, you first have to provoke a connection utilizing the mysql.connector. You may study the best way to create a connection to MySQL right here.
Methods to Create a Database in Python
Making a database is straightforward.
First, be sure to have an lively connection to your database, after which set a cursor.
After getting 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")
Methods to Test if a MySQL Database Exists in Python
Utilizing an identical 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)
Methods to Hook up with a MySQL Database in Python
Now that you realize which database to connect with, you’ll be able to specify it immediately at first.
import mysql.connector
mydb = mysql.connector.join(
host = "localhost",
consumer = "username",
password = "YoUrPaSsWoRd",
database="your_database"
)
