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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]