Re: Show Grants problem

2006-04-15 Thread Shawn Green
--- Todd Smith <[EMAIL PROTECTED]> wrote: > Hello > Does anyone know why a user would show up in a select from user > query but > not in a show grants command. What I am trying to say is I tried > SHOW > GRANTS FOR 'user1'@'%' and received that there is no such grant > defined for > 'user

Show Grants problem

2006-04-13 Thread Todd Smith
Hello Does anyone know why a user would show up in a select from user query but not in a show grants command. What I am trying to say is I tried SHOW GRANTS FOR 'user1'@'%' and received that there is no such grant defined for 'user1'... But when I run SELECT * FROM user WHERE User = 'user