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,



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to