how do I "show grants?"

[sfullman]

HI there,

I'm able to list tables, databases, fields, etc.. but I recently got stumped on this one.

How would I display, using php, the result set of "show grants for soandso"? do I use mysql_fetch_array? That didnt seem like it worked.

Thanks!!!

Sam Fullman

[statrat]

it works for me.

<?php

$link=mysql_connect($dbhost, $dbusername, $dbuserpassword);
mysql_select_db($default_dbname);

$query="Show grants for soandso@localhost";

if($result=mysql_query($query)){
	while($row=mysql_fetch_array($result)){

	echo $row[0];

	}
}
?>

[nnichols]

You can do it as 'statrat' suggested but I find it much easier to work directly with the grant tables when editing/displaying permissions data.