Hi,
I've put here this my problem, but without an answer.
If I (admin1) have all privileges with grant option on database 'db1' and
no privileges in 'mysql', why this does not work
mysql> grant all privileges on db1.* to aaa@localhost identified by 'aaa';
ERROR 1044: Access denied for user:
Hello,
My idea is to have several (about 3) databases. Each DB will have one
admin, who is responsible for this DB and doesn't have access to other DBs.
The problem is, how to set privileges?
I did:
GRANT ALL PRIVILEGES on DB1.* to admin1@localhost WITH GRANT OPTION;
Then if admin1 is connec