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 'user1'... But

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 =