Re: [PHP-DB] db privileges

Hey Frank,

I wasn't able to run the query:
select * from mysql.user where concat(user, '@', host) like (select
CURRENT_USER())

because I didn't have privileges to view the table, but I was able to root
around the INFORMATION_SCHEMA table and find what I needed.

thanks!

patrick

On Tue, Jan 6, 2009 at 2:08 PM, Frank Flynn <[email protected]> wrote:

>
> On Jan 6, 2009, at 7:41 AM, [email protected] wrote:
>
>
>> I was wondering if there is a php function
>> and/or mysql function that can be run from php to find out the privileges
>> for a particular db connection.  Any ideas?
>>
>
> Just to get you started try:
>
>   select * from mysql.user where concat(user, '@', host) like (select
> CURRENT_USER())\G
>
> That worked for me, I'm sure you can go join to INFORMATION_SCHEMA and do
> more exotic (more precise) things too.
>
> Good Luck,
> Frank
>