查询mysql中所有数据库名称
SELECT `SCHEMA_NAME`
FROM `information_schema`.`SCHEMATA`
php代码实现读取mysql数据库中所有数据库名称的代码
<?php
$user = 'root';
$pwd = '';
$host = 'localhost';
$conn = mysql_connect($host,$user,$pwd);
$sql = "SELECT `SCHEMA_NAME` FROM `information_schema`.`SCHEMATA`";
$query = mysql_query($sql);
while($rs = mysql_fetch_array($query))
{
echo $rs[0]."<br/>";
}
?>