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