Physical Address
304 North Cardinal St.
Dorchester Center, MA 02124
Physical Address
304 North Cardinal St.
Dorchester Center, MA 02124
In an effort to create a MySQL database in Python, you first have to provoke a connection utilizing the mysql.connector
. You possibly can study how you can create a connection to MySQL right here.
Making a database is easy.
First, ensure you have an energetic connection to your database, after which set a cursor
.
After getting this, concern 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")
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)
Now that which database to connect with, you’ll be able to specify it immediately to start with.
import mysql.connector
mydb = mysql.connector.join(
host = "localhost",
consumer = "username",
password = "YoUrPaSsWoRd",
database="your_database"
)