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@ipaddress' to database
'mydb'. The Revoke statement
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.
- Original Message -
From: [EMAIL PROTECTED]
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
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 database_name.* TO user_name@localhost
PCP ERROR 1044: Access denied for user: 'user_name@localhost' to database
PCP
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
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
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 fine, until
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 from
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 %-wildcard includes
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 ist good
10 matches
Mail list logo