List:General Discussion« Previous MessageNext Message »
From:Hiep Nguyen Date:April 15 2008 1:03pm
Subject:grant user privileges
View as plain text  
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,
Thread
grant user privilegesHiep Nguyen15 Apr
  • Re: grant user privilegesSrini16 Apr
  • Re: grant user privilegesSebastian Mendel16 Apr
    • Re: grant user privilegesSebastian Mendel17 Apr
  • Re: grant user privilegesDaniel Brown16 Apr
    • Re: grant user privilegesHiep Nguyen16 Apr
      • Re: grant user privilegesDaniel Brown16 Apr