List:General Discussion« Previous MessageNext Message »
From:Ed Carp Date:August 4 2002 7:02pm
Subject:RE: users and db visibility
View as plain text  
> -----Original Message-----
> From: tlr7425@stripped [mailto:tlr7425@stripped]
> Sent: Sunday, August 04, 2002 3:17 AM
> To: Hussein Morsy; MySQL List
> Subject: Re: users and db visibility
> 
> on 8/4/02 3:13 AM, Hussein Morsy, typed:
> 
> >> how can i make MySQL show only what db are available to the user?
> >> i.e., when a user logs in from a terminal application and types:
> >> 'show databases;'
> > 
> > mysqld --safe-show-database
> > or in my.cnf:
> > safe-show-database
> > 
> > With this option, the SHOW DATABASES command returns only those
> > databases for which the user has some kind of privilege. In 4.0.2 this
> > option is default enabled.
> 
> thanks.
> i just searched:
> http://www.mysql.com/doc/en/index.html
> for
> my.cnf 
> and got no returns.
> 
> i searched my system for it and couldn't find it.
> 
> can you tell me something about it, like maybe where it could be?

Yes, well, a quick 30 seconds worth of work:

(1) go to mysql.com
(2) click on "Search"
(3) Type in "--safe-show-database" in the box
(4) click on "Search1"

Volia!

For the truly lazy, here's a link to get you started:

http://www.mysql.com/doc/en/Command-line_options.html
--
Ed Carp, N7EKG          http://www.pobox.com/~erc               214/986-5870
Director, Software Development
Escapade Server-Side Scripting Engine Development Team
Pensacola - Dallas - London - Dresden
http://www.squishedmosquito.com 
Thread
users and db visibilitytlr74254 Aug
  • Re: users and db visibilityHussein Morsy4 Aug
Re: users and db visibilitytlr74254 Aug
  • RE: users and db visibilityEd Carp4 Aug
    • Re: users and db visibilitytlr74255 Aug