Re: Every user can access the databases

2002-05-06 Thread Victoria Reznichenko
Dennis, Monday, May 06, 2002, 4:51:50 PM, you wrote: D> I have tried almost everything and nothing works. D> The problem is, I have a server with different MySQL databases from D> different people. D> User 1 should not access database 2 and user 2 should not access database 1. D> What is the e

RE: Every user can access the databases

2002-05-06 Thread Gurhan Ozen
GRANT ALL PRIVILEGES ON databasename.* TO user IDENTIFIED BY 'password'; http://www.mysql.com/doc/G/R/GRANT.html Gurhan -Original Message- From: Dennis [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 9:52 AM To: [EMAIL PROTECTED] Subject: Every user can access the dat

RE: Every user can access the databases

2002-05-06 Thread Jay Blanchard
[snip] The problem is, I have a server with different MySQL databases from different people. User 1 should not access database 2 and user 2 should not access database 1. What is the easiest way to prevent user 1 to access database 2. I can't get it right. [/snip] http://www.mysql.com/doc/G/R/GR

Every user can access the databases

2002-05-06 Thread Dennis
I have tried almost everything and nothing works. The problem is, I have a server with different MySQL databases from different people. User 1 should not access database 2 and user 2 should not access database 1. What is the easiest way to prevent user 1 to access database 2. I can't get it rig