On Wed, Apr 16, 2008 at 1:18 PM, Hiep Nguyen <[EMAIL PROTECTED]> 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! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]