> -----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
