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]