检查数据库是否存在

  1. import mysql.connector
  2.  
  3. mydb = mysql.connector.connect(
  4. host="localhost",
  5. user="myusername",
  6. passwd="mypassword"
  7. )
  8.  
  9. mycursor = mydb.cursor()
  10.  
  11. mycursor.execute("SHOW DATABASES")
  12.  
  13. for x in mycursor:
  14. print(x)