mysql怎么查询数据库名字

SHOW DATABASES;

SELECT SCHEMA_NAME FROM information_schema.SCHEMATA;

SELECT DISTINCT(db) FROM mysql.db;

import mysql.connector

try:
    # 连接到MySQL服务器
    connection = mysql.connector.connect(host='localhost',
                                         user='your_username',
                                         password='your_password')
    
    if connection.is_connected():
        cursor = connection.cursor()
        cursor.execute("SHOW DATABASES")
        
        # 获取并打印所有数据库名字
        databases = cursor.fetchall()
        for db in databases:
            print(db[0])
except mysql.connector.Error as e:
    print(f"Error while connecting to MySQL: {e}")
finally:
    if connection.is_connected():
        cursor.close()
        connection.close()
        print("MySQL connection is closed")