Re: Setting user passwords per database

2001-08-27 Thread Mark Johnson
Sent: Monday, August 27, 2001 5:35 AM Subject: Re: Setting user passwords per database > It would see you could us ethe GRANT command: > > GRANT ALL PRIVILEGES ON database1.* TO user@"%" IDENTIFIED BY 'password1'; > GRANT ALL PRIVILEGES ON database2.* TO user@"

Re: Setting user passwords per database

2001-08-27 Thread Gerald R. Jensen
IDENTIFIED BY 'password3'; - Original Message - From: "Mark Johnson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, August 26, 2001 10:40 PM Subject: Setting user passwords per database Is it possible to set a di

Re: Setting user passwords per database

2001-08-26 Thread Jeremy Zawodny
On Sun, Aug 26, 2001 at 10:40:20PM -0500, Mark Johnson wrote: > > Is it possible to set a differenent password per database for the > same user? It doen't appear to be possible Not that I know of. The user is tied to a single password. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Tech

Setting user passwords per database

2001-08-26 Thread Mark Johnson
Is it possible to set a differenent password per database for the same user? It doen't appear to be possible - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/