Hi Paul, FLUSH PRIVILEGES; <--------------------- missing hahaha....
That's the command I didn't use after the commands you asked me to put in before... it is working know... I can't see mysql. I can see testdb and test... thank you very much for your help.... Cheers, Clive -----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 | 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? > >> >>Cheers, > >Clive -- 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]
