show data bases

turki

i'm using this code to show all databases ,

but i see only user databases n't all

do any one konw how i can send this query ass root to see all data bases?


<?
  $query = "SHOW DATABASES ;";
    	$result = mysql_query($query) or die("Query failed");
?>
 <div align="center">
  <center>
 <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="50%" id="AutoNumber1">




<?php



while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {

    foreach ($line as $col_value) {

             print "<tr><td width='50%'>$col_value</td>";
             print "<td width='50%' align='center'>
<form method='POST' action='checkdata.php?ID=$ID&user=$user&pass=$pass&data=$col_value'>
     <input type='submit' value='$checknow\n$col_value' name='B1'>
</form>

</td></tr>";



}


mysql_free_result($result);


  }

?>

ScubaKing22

Try connecting to the database using root as a username:
mysql_connect("host","root","pass")
By default there is no password for root, but if you're running off of a different host they have most likely made a password for root and so a user can only see specific databases.

turki

thanx ScubaKing22

i't ok now after i used root password,

now ...

how i can use mysqlcheck and show result in browse ?

thank you