At 12:00 -0600 1/14/06, Fletcher Mattox wrote:
Hi,
Is it possible for one user to have more than one password; one
for each database? My naive attempt at this was
No. An "account" in MySQL is defined the by combination of username
and hostname that you specify after the TO in the grant statement.
Both your statements apply to the same account, so the password in
the second statement simply replaces the existing password, as
you've discovered.
GRANT ALL ON db1.* TO 'fletcher'@'%' IDENTIFIED BY pass1
GRANT ALL ON db2.* TO 'fletcher'@'%' IDENTIFIED BY pass2
But I find that pass2 replaces pass1 on db1 when I do this.
What am I missing? This is MySQL 4.1.7.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
