On Wed, Apr 16, 2008 at 1:18 PM, Hiep Nguyen <hiep@stripped> wrote:
>
> is there any command that can set so that admin's privileges on internal =
> admin's privileges on test???
>
> what i'm trying to avoid is manually adjust admin's privileges on test if
> admin's privileges on internal changed.
>
> if it's not still clear, then stupid me....never mind.
If I'm understanding correctly, you want user 'admin' to be able
to access multiple databases, using one password and one permission
set. If that's the case, then yes, it can be done.... but as far as I
know, only by selecting ALL databases.
Such as:
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' IDENTIFIED BY
'passwordString';
FLUSH PRIVILEGES;
Then, when updating privileges for 'admin', just include *.*
instead of a particular database.table limit.
Keep in mind, though, that 'admin' will then have access to EVERY
database on the server. I'm not sure that there's a way to
comma-delimit (or something of the type) a select few database.table
configurations. A quick search of the web didn't show any different
either.
--
</Daniel P. Brown>
Ask me about:
Dedicated servers starting @ $59.99/mo., VPS starting @ $19.99/mo.,
and shared hosting starting @ $2.50/mo.
Unmanaged, managed, and fully-managed!
