import mysql.connector

dbname = (
  local = "localhost",
  user = "root",
  passwd= "YourPass",
  database="YourDataBase"
)

mycursor = dbname.cursor()

myscursor.execute("SHOW TABLES")

for consult in mycursor:
  print(dbname)