| localhost | testdb | testuser | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | Y | Y |
the N is Grant_priv
I don't understand why? thanks...
Don't understand what? Why Grant_priv is N? It's not included in "ALL PRIVILEGES".
As far as being able to access the mysql database, apparently you've granted global access to it, or any-user access to it at the database level. Does SELECT * FROM mysql.db 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/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 on mysql.user.
just an info.
select * from mysql.user where user='testuser';
| localhost | testuser | xxxxxxxxxxxxx | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 |
any clue?
What does SELECT * FROM mysql.db WHERE User='testuser' show?
>Clive
Cheers,
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
