creating db admins

2003-07-19 Thread Ed Brown
I create a database, foo, then designate a user, pooh, with full privileges, including grant option (pooh is to administer this database, including creating other users): grant all on foo.* to 'pooh'@'localhost' identified by 'zoo' with grant option; Now pooh logs in to the mysql server

(more concise) db admin question

2003-07-19 Thread Ed Brown
To restate an earlier question more concisely: Is it true that a user who is given all privileges, including grant option, on a database (e.g., in order to administer that database) can create other users with any or all of his privileges, but cannot give them passwords? Is there some wa