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 statem
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
