KEVIN ZEMBOWER writes:
> mysql> grant all on zope.* to zope identified by "xxxxxxx"; > Query OK, 0 rows affected (0.00 sec) > > mysql> select * from user where user="zope"; > | % | zope | 34577362486f3680 | N | N | N | N > | N | N | N | N | N | N > | N | N | N | N | > My questions: > 1. Why didn't this work? It did work. You granted all privileges on the database zope, but the privileges in the 'user' table are the _global_ privileges. Those are what you set with GRANT ... ON *.* ... To see the ones you set, have a look in the table 'db'. > 2. If it had worked, would I have seen something other than "zero records affected" >in response to the GRANT command? For some reason you always get a 0 back from GRANT. There's probably some internal reason for this. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. --------------------------------------------------------------------- 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