I do. Is it possible? The grant tab seems to be based off a list from mysql.user Which is the check that is being prevented with "PMA_DBI_try_query('SELECT COUNT(*) FROM mysql.user', $GLOBALS['userlink'], PMA_DBI_QUERY_STORE)" to set the superuser
-Aaron T. Maturen
----- Original Message ----- From: "Marc Delisle" marc@infomarc.info To: phpmyadmin-devel@lists.sourceforge.net Sent: Wednesday, April 14, 2010 9:29:35 AM GMT -05:00 US/Canada Eastern Subject: Re: [Phpmyadmin-devel] 1295022 - Privileges for non superuser
Aaron Maturen a écrit :
I guess I'm getting tired. Its already part of adding a new user. Just for reference heres the link to the bug tracker: https://sourceforge.net/tracker/index.php?func=detail&aid=1295022&gr... .
Aaron, just to be sure, do you still have a question about this?
Aaron Maturen a écrit :
I do. Is it possible? The grant tab seems to be based off a list from mysql.user Which is the check that is being prevented with "PMA_DBI_try_query('SELECT COUNT(*) FROM mysql.user', $GLOBALS['userlink'], PMA_DBI_QUERY_STORE)" to set the superuser
-Aaron T. Maturen
From the MySQL doc:
"SHOW GRANTS requires the SELECT privilege for the mysql database."
So you need this kind of privileges to be able to list privileges for other users, unless there is some other way that I'm not aware of.
In the RFC, the person mentions that the account he's trying to use is allowed to do GRANT to create users, so maybe he also has SELECT on the "mysql" database?
----- Original Message ----- From: "Marc Delisle" marc@infomarc.info To: phpmyadmin-devel@lists.sourceforge.net Sent: Wednesday, April 14, 2010 9:29:35 AM GMT -05:00 US/Canada Eastern Subject: Re: [Phpmyadmin-devel] 1295022 - Privileges for non superuser
Aaron Maturen a écrit :
I guess I'm getting tired. Its already part of adding a new user. Just for reference heres the link to the bug tracker: https://sourceforge.net/tracker/index.php?func=detail&aid=1295022&gr... .
Aaron, just to be sure, do you still have a question about this?
-
Aaron Maturen -
Marc Delisle