PHP获取MySQL所有数据库

需要root账户权限

$conn = mysqli_connect("localhost", "root", "123456") or die("数据库服务器连接失败");
$ret = mysqli_query($conn, "SHOW DATABASES");

//遍历方式一
while ($row = mysqli_fetch_object($ret))
{
    echo $row->Database . "<br>";
}

//遍历方式二
while ($row = mysqli_fetch_assoc($ret))
{
    echo $row['Database'] . "<br>";
}

mysqli_close($conn);