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]";
}
I believe this only returns a single row with the grant sta
Can I create a php script like:
$privSQL = "SHOW GRANTS FOR 'paul'@'localhost'";
$priv_result = mysql_query($privSQL) or die("Couldn't Select Priv");
$k=0;
for ($i=0;$i";
}
to print out the results to the browser.?
I tried this but I couldn't get past mysql_query
Chris
"Paul DuBois" <[EMAI
At 20:24 -0500 1/8/04, Chris wrote:
I am just a user (not an administrator) and would like to know what
privileges I have with my MySQL user account. Is there a SELECT command I
can construct that will list these privileges?
Yes, SHOW GRANTS:
http://www.mysql.com/doc/en/SHOW_GRANTS.html
Issue a S
