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, and tries to use his grant option
to create another user. This fails:
grant select on foo.* to 'moo'@'localhost' identified by 'goo';
ERROR 1044: Access denied for user: 'pooh@localhost' to database 'mysql'
but this succeeds:
grant select on foo.* to 'moo'@'localhost';
Query OK, 0 rows affected (0.00 sec)
Now moo can log in without a password. So pooh can create a new user
with any of pooh's privileges to database foo, but pooh cannot give the
new user a password?! What am I missing? ('set password', or inserts
or modify, don't work either) Does it really take root (or another
superuser)
to create a password?
TIA!
-Ed
I
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw