List:General Discussion« Previous MessageNext Message »
From:Sebastian Mendel Date:April 17 2008 5:34am
Subject:Re: grant user privileges
View as plain text  
Sebastian Mendel schrieb:
> Hiep Nguyen schrieb:
>> 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.
> 
> grant access to admin from 'foreign' hosts?
> 
> "10.0.0.0.%" is not the host admin connects from but _TO_!
> 
> this must be the host of the MySQL server, the host that is specified 
> when connecting _TO_ the database.


sorry, bulls***, i was totally wrong, of course ...

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