[Phpmyadmin-devel] CREATE TEMPORARY TABLE global priv
DelislMa at CollegeSherbrooke.qc.ca
Tue Mar 25 03:31:47 CET 2003
> Hi Robin & list,
> -----Original Message-----
> From: Robin H. Johnson
>>On Mon, Mar 24, 2003 at 09:37:00AM -0500, Marc Delisle wrote:
>>>Well, after reading their answer, I guess we will have to rely on
>>>something else to set $is_superuser, like selecting records from
>>Agreed. We will have to just follow how GRANT/REVOKE work and
>>build up the permissions ourselves. Or use SHOW GRANTS and some work.
> Please avoid SHOW GRANTS. It's a little buggy in early 4.0 / 3.23
> And the big problem is that we have to know the correct Hostname as it
> appears in the user table.
> e.g. if user foo at 192.168.0.% logs on from 192.168.0.26 we would
> intentionally build this query:
> SHOW GRANTS FOR foo at 192.168.0.26;
> Unfortunally, this query would fail.
> The only way to determine a user's privileges properly is to use the
> `mysql` database. We should use the controluser for this purpose.
> Alexander M. Turek
> <alex at bugfixes.info>
Change implemented in main.php3.
More information about the Developers