Connect with mysql database using mysql.connector and 'SHOW DATABASES'.

mysqlconnect.py

import mysql.connector

conn = mysql.connector.connect(host="localhost", user="root", passwd="root", 
                            #database='',
                            auth_plugin='mysql_native_password') # for MySQL 8.0 above

print(conn)

cursor = conn.cursor()
databases = ('show databases')
cursor.execute(databases)

print(cursor)
for databases in cursor:
    print(databases)

conn.close()