mysql grant

admin

Administrator
Staff member
Using mysql on Win98 ...

Created a user 'ed'.

Tried to grant 'ed' privileges on all databases named "team.*".

Used the following command:

mysql> grant select,insert,update,delete,index,alter,create,drop
-> on team.*
-> to ed;

This worked OK, except that in the 'db' table the following were added as a result:
Host: %
Db: team
User: ed

So, if I try to create a database called 'team.1', I get an error. I can ONLY create a database named 'team'.

Can anyone help me?
 
Back
Top