mysql数据库名查看

mysql -u 用户名 -p
SHOW DATABASES;

import pymysql

# 连接数据库
connection = pymysql.connect(host='localhost', user='用户名', password='密码', db='mysql')

# 获取数据库游标
cursor = connection.cursor()

# 查询数据库名
cursor.execute("SHOW DATABASES")

# 获取查询结果
databases = cursor.fetchall()

# 打印数据库名
for database in databases:
    print(database[0])

# 关闭游标和连接
cursor.close()
connection.close()

<?php
$servername = "localhost";
$username = "用户名";
$password = "密码";

// 创建连接
$conn = new mysqli($servername, $username, $password);

// 检查连接
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 查询数据库名
$sql = "SHOW DATABASES";
$result = $conn->query($sql);

// 输出查询结果
if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo $row["Database"]. "<br>";
    }
} else {
    echo "0 结果";
}

// 关闭连接
$conn->close();
?>