one user, multiple passwords

Sat, 14 Jan 2006 10:01:02 -0800 

Hi,

Is it possible for one user to have more than one password; one
for each database?  My naive attempt at this was

        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.

Thanks
Fletcher

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to