ive
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Monday, October 27, 2003 1:15 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: How do I restrict a mysql user only can work on a database
At 1:06 PM +1100 10/27/03, Clive Luk wrote:
>| localhost | testdb | testu
WHERE Db='mysql' show anything?
Cheers,
Clive
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Monday, October 27, 2003 1:04 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: How do I restrict a mysql user only can work on a database
At 12:48 PM +1100 10/
ginal Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Monday, October 27, 2003 1:04 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: How do I restrict a mysql user only can work on a database
At 12:48 PM +1100 10/27/03, Clive Luk wrote:
>Hi paul,
>
>Thanks for the qui
At 12:48 PM +1100 10/27/03, Clive Luk wrote:
Hi paul,
Thanks for the quick reply.
I have revoke all the privileges and ran
grant all privileges on testdb.* to [EMAIL PROTECTED];
and i login as testuser and i have confirm with select Current_user(); that
i am a testuser;
and i can still select o
PROTECTED]; [EMAIL PROTECTED]
Subject: RE: How do I restrict a mysql user only can work on a database
At 12:26 PM +1100 10/27/03, Clive Luk wrote:
>Thanks Paul,
>
>but how do i reset all the previous setting before I try to run the command
>again? Or do I need to reset the privile
DuBois [mailto:[EMAIL PROTECTED]
Sent: Monday, October 27, 2003 12:21 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: How do I restrict a mysql user only can work on a database
Please reply to the list, not to me personally, so that others can
follow this discussion.
At 12:13 PM +1100 10/27
PROTECTED]
Subject: RE: How do I restrict a mysql user only can work on a database
Please reply to the list, not to me personally, so that others can
follow this discussion.
At 12:13 PM +1100 10/27/03, Clive Luk wrote:
>it says the following..
>
>mysql> select
ot;the testdb table in the current database", which isn't
what you want.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Monday, October 27, 2003 12:10 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: How do I restrict a mysql user only can work on a databa
I'll bet the real problem is that you're not being authenticated as
testuser.
After you try connecting to the server as testuser, issue this query:
SELECT CURRENT_USER();
What's the result?
At 11:57 AM +1100 10/27/03, Clive Luk wrote:
Hi all,
I have a question. I have created
=
Hi all,
I have a question. I have created
===mysql_command start==
mysql> GRANT ALL PRIVILEGES ON testdb to [EMAIL PROTECTED]
-> identified by 'some_passwd';
===mysql_command end==
the user can login no p
10 matches
Mail list logo
