3 messages in com.mysql.lists.mysqlFwd: Re: how to restrict a user to on...
FromSent OnAttachments
Shakaib Sayyid13 Oct 2000 00:28 
Shakaib Sayyid13 Oct 2000 12:11 
Paul DuBois13 Oct 2000 13:53 
Subject:Fwd: Re: how to restrict a user to one and only one DB---HELP
From:Shakaib Sayyid (shak@kode.net)
Date:10/13/2000 12:11:34 PM
List:com.mysql.lists.mysql

I tried using GRANT but still I am able to do describe tables and do SQL queries
on DB's that are not mine.

(I need to get a copy of the MySQL book).

Thanks

On Fri, 13 Oct 2000 12:25:17 -0700, Ian Gan wrote:

Try:

GRANT ALL ON database_name.* TO user@yourhost.com IDENTIFIED by "password"

See pg. 422 in Paul Dubois's MYSQL book - ian

----- Original Message ----- From: Shakaib Sayyid <shak@kode.net> To: <mys@lists.mysql.com> 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('217.207.217.234', 'sjs', password('123')); insert into db (host,db,user) values('217.207.217.234', '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 to 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 completely hidden to him.

Thanks all.

--

--------------------------------------------------------------------- Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail mysq@lists.mysql.com

To unsubscribe, send a message to: <mysql-unsubscribe-woktoc=pd.j@lists.mysql.com>

If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php

===================END FORWARDED MESSAGE===================