I seem to be having some trouble with using GRANT and REVOKE. I am
implementing a "user management" form in my application that does the
following:
REVOKE ALL ON mydb.* FROM 'Username'@'%'
I get an error "Access denied for user: 'MyAdmin@' to dat
Just installed the mysql binary. It runs fine.
However the only way i can administrate it is if I use
the root account which is fine. But when I try to
Grant other users any privilages the following
happens:
My Query: Grant ALL on dbName.* to userName
Response: Query Ok, 0 rows affected.
Pradeep.C.Pangi,
Tuesday, June 25, 2002, 5:02:38 PM, you wrote:
PCP> I am getting a following error message when I do the GRANT SELECT,
PCP> INSERT, DELETE, UPDATE ON .* TO
PCP> ERROR 1044: Access denied for user: '@localhost' to database
PCP>
PCP> Please Help me regarding this.
To set u
ROTECTED]>
To: Pradeep.C.Pangi <[EMAIL PROTECTED]>
Sent: Tuesday, June 25, 2002 7:24 PM
Subject: Re: Regarding GRANT and REVOKE
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one
Joerg,
Thursday, February 28, 2002, 2:28:27 PM, you wrote:
JH> Hello Victoria Reznichenko,
JH> thanks for your answer, but i think this is not absolutly true
[skip]
JH> But now there is the next question :
JH> This entry ""@localhost was made my mysql_install_db .
JH> Do i need it ? What was is
John,
Thursday, February 28, 2002, 1:56:29 PM, you wrote:
>>JH> i like to have a DB per user so i do
>>
>>JH> GRANT ALL ON username.* TO username@"%" IDENTIFIED BY 'password';
>>
>>JH> This is fine, until the user tries to connect from localhost :(
>>JH> As i read the manual i think the %-wildcar
On Thursday, 28. February 2002 12:02, you wrote:
Hello Victoria Reznichenko,
thanks for your answer, but i think this is not absolutly true
> JH> As i read the manual i think the %-wildcard includes localhost .
> JH> But i can not get it to work that way :(
> JH> My users have to have access fr
And if we where talking about MySQL on Windows
At 13:02 28/02/2002 +0200, Victoria Reznichenko wrote:
>Joerg,
>Thursday, February 28, 2002, 12:03:18 PM, you wrote:
>
>JH> i like to have a DB per user so i do
>
>JH> GRANT ALL ON username.* TO username@"%" IDENTIFIED BY 'password';
>
>JH> This is f
Joerg,
Thursday, February 28, 2002, 12:03:18 PM, you wrote:
JH> i like to have a DB per user so i do
JH> GRANT ALL ON username.* TO username@"%" IDENTIFIED BY 'password';
JH> This is fine, until the user tries to connect from localhost :(
JH> As i read the manual i think the %-wildcard includes
Hi all,
i like to have a DB per user so i do
GRANT ALL ON username.* TO username@"%" IDENTIFIED BY 'password';
This is fine, until the user tries to connect from localhost :(
As i read the manual i think the %-wildcard includes localhost .
But i can not get it to work that way :(
My users have
10 matches
Mail list logo
