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?
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?