--- 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 when I run SELECT * FROM user WHERE User = 'user1' I > do get > results. Could the user have been added using an insert causing the > SHOW > GRANTS to fail? > > > Any Ideas > > Todd > Todd, Users are identified by more than just their login name. Users are a combination of login AND a "host" specifier. When you do SELECT * from user where user = 'user1'; a) how many entries are there b) what is in the host column for those entries. For example if the host column shows "fizzle.shizzle.com" then you have to use SHOW GRANTS FOR 'user1'@'fizzle.shizzle.com'; HTH! Shawn Green Database Administrator Unimin Corporation - Spruce Pine __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]