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
