I believe that phpmyAdmin uses the "show databases" syntax to see what is available. To prevent it from seeing any db which the user is not authorized, set the safe_show_database = 1 in the my.ini file (or my.cnf). This will prevent show databases from returning a list of all dbs available.
kelly >I’m running MySQL on my Win98 Desktop and I’ve created a new user and only >granted access to one database, but when I use myPhpAdmin the user can >still >see all the databases. What can I do so that each user only see the >databases they have access too. > >"Always an Email Away" > Kevin Campbell > Chief Executive Officer > The Club Mix, Inc. > http://www.theclubmix.com > ------------------ Kelly Firkins [EMAIL PROTECTED] _________________________________________________________________ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.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
