> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > 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 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php