You can SHOW GRANTS FOR foo which gives you information about user 'foo'. To show info about everyone, use SELECT * FROM user;
hth Doug On Sat, 16 Feb 2002 13:59:02 +0100, Søren Neigaard wrote: >I'm a total newbie to MySQL, so I'm reading the documentation right >now. In "General Security" I read that "SHOW GRANTS" should give me a >picture of who has what rights, but if I use "SHOW GRANTS" I get the >following error: ERROR 1064: You have an error in your SQL syntax near '' at line 1 > >What am I doing wrong? > >-- >Med venlig hilsen/Best regards, > Søren Neigaard mailto:[EMAIL PROTECTED] >-- > "Everything should be made as simple as possible, but no simpler." > > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php