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? i'm using MySQL 3.23.51.thanks in advance, Lloyd --------------------------------------------------------------------- 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