phpMyAdmin Privileges Query
am 05.07.2010 02:21:21 von Michael Trewartha --_000_0A2D7E9D0655CD41A6327C0E1EA88C6E0465B446B0MAILBOXcorp ad_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hello, just wondering if anyone can advise the query that phpMyAdmin genera=
tes to list all the privileges for a specific database.
What I'm after is an output like:
+-----+------------+----------------------+-------------+
|User | Host | Type | Privileges |
+-----+------------+----------------------+-------------+
| A | a.b.c.d | global | S, I, U, D |
| B | localhost | database-specific | S, I, U |
+-----+------------+----------------------+------------+
Thanks,
Mike.
________________________________
Adam Internet accepts no liability for the content of this e-mail, or for t=
he consequences of any actions taken on the basis of the information provid=
ed, unless that information is subsequently confirmed in writing. Any views=
or opinions presented in this e-mail are solely those of the author and do=
not necessarily represent those of Adam Internet. If you are not the inten=
ded recipient you must not distribute or copy this transmission and should =
notify the sender of the error. You must not forward, in part or in full, t=
he contents of the e-mail to any recipient unless granted explicit permissi=
on from the sender.
WARNING: Computer viruses can be transmitted via e-mail. The recipient shou=
ld check this email and any attachments for the presence of viruses. Adam I=
nternet accepts no liability for any damage caused by any virus transmitted=
by this e-mail.
--_000_0A2D7E9D0655CD41A6327C0E1EA88C6E0465B446B0MAILBOXcorp ad_--