Can I create a php script like:No. Try this:
$privSQL = "SHOW GRANTS FOR 'paul'@'localhost';";
$priv_result = mysql_query($privSQL) or die("Couldn't Select Priv");while($myrow = mysql_fetch_row($priv_result))
{
echo "$myrow[0]<br>";
}I believe this only returns a single row with the grant statement used to create the account, so you really don't need the loop at all, just this:
$myrow = mysql_fetch_row($priv_result); echo "$myrow[0]<br>";
_________________________________________________________________
Get reliable dial-up Internet access now with our limited-time introductory offer. http://join.msn.com/?page=dept/dialup
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
