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