At 12:11 PM -0700 10-13-2000, Shakaib Sayyid wrote:
>I tried using GRANT but still I am able to do describe tables and do
>SQL queries on DB's that are not mine.
That will happen if you use GRANT without removing the (too-permissive)
privileges that you've already set up.
>(I need to get a copy of the MySQL book).
No argument here. :-)
>On Fri, 13 Oct 2000 12:25:17 -0700, Ian Gan wrote:
>>GRANT ALL ON database_name.* TO username@stripped IDENTIFIED by
>>See pg. 422 in Paul Dubois's MYSQL book - ian
>>----- Original Message -----
>>From: Shakaib Sayyid <shakaib@stripped>
>>Sent: Friday, October 13, 2000 12:29 AM
>>Subject: how to restrict a user to one and only one DB---HELP
>>I have just set a MySQL db on a RH6.2 DB and its working fine.
>>However, I am not able to set a user so that he STRICTLY can access only one
>>db he is assgined to.
>>I have done it the follwoing way:
>>insert into user(host,user,password) values('18.104.22.168', 'sjs',
>>insert into db (host,db,user) values('22.214.171.124', 'forum','sjs');
>>and the rest the fields set to N in user and to Y in db. The strange thing
>>is that I have MySQLWinAdmin (an MS-Win db admin), using which if I connect
>>the db then I am able to see all the other db's, well I cannot make any
>>changes but I can see what all is there in other db's (apart from forum).
>>How can I avoid this, like just have the user sjs who should be able to see
>>only his own db like forum in this case. And the other dbs should be
> >hidden to him.
Paul DuBois, paul@stripped