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, 2
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 wh
Hey all,
I ran across a problem while trying to run a delete query. The website that
I am working on has multiple users in the db for various logins and I was
inadvertently using a less-privileged account and found I couldn't make
delete queries run successfully. I eventually found out the probl
