Python MySQL Create Database

To create a database in MySQL, use the "CREATE DATABASE" statement:

Example create a database named "mydatabase":

host="localhost", user=" yourusername ", password=" yourpassword " )

mycursor.execute("CREATE DATABASE mydatabase") If the above code was executed with no errors, you have successfully created a database.

You can check if a database exist by listing all databases in your system by using the "SHOW DATABASES" statement:

Return a list of your system's databases:

host="localhost", user=" yourusername ", password=" yourpassword " )

mycursor.execute("SHOW DATABASES") for x in mycursor:

Or you can try to access the database when making the connection:

Try connecting to the database "mydatabase":

host="localhost", user=" yourusername ", password=" yourpassword ", database="mydatabase" ) If the database does not exist, you will get an error.