import mysql.connector mydb = mysql.connector.connect( host = "localhost", user = "root", password = "mypasswd",) cursor = mydb.cursor() cursor.execute("SHOW DATABASES")
def list_databases(connection): mycursor = connection.cursor() mycursor.execute('SHOW DATABASES') databases = mycursor.fetchall() for db in databases: print(db)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)