Re: grant user privileges

[Srini]

Can you give the output of the command

show grants for admin;

Thank You,

-srini

Hiep Nguyen wrote:
> hi all, i have an existing database (internal) with a user named 
> 'admin', everything works fine as far as privileges concern.
>
> i just created a new database (test) and want to grant admin's 
> privileges on test as same as internal.
>
> how do i do this???
>
> i tried (as root):
>
> grant all on test.* to 'admin'@'localhost';
> grant all on test.* to 'admin'@'10.0.0.%';
>
> but it seems not right.
>
> thanks,
>