Granting Privileges

[NeoGeo]

I want to set up a user in mysql that can use select commands on one of the databases - this is the command I issue for that:

grant select on mydb.* to view@localhost identified by 'view';

Now, after that if I issue this command:

select User, Select_priv from user;

I get

User Select_priv
view N

Am I doing something wrong? I would just insert a user but I don't know how to specify a database doing that. If anyone knows how to insert a user AND specify a database that would work too.

Thanks,
Ben

[jerdo]

Try using phpMyAdmin it makes setting up users so much easier.