My apologies, I was writing that from work, without immediate access to a box running mysql. I tried it just now and have been having problems attempting to put it into a config file. So far, I've only been able to get it to work by passing --safe-show-database to the service as it starts. If/when I discover how to add this option to the my.cnf file I'll let you know.
Kelly ----- Original Message ----- From: "Mike(mickalo)Blezien" <[EMAIL PROTECTED]> To: "Kelly Firkins" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, December 12, 2001 11:36 AM Subject: Re: Each user have only see databases they have access too Which group(s) would this go under in the my.cnf ?? >On Wed, 12 Dec 2001 07:27:54 -0600, "Kelly Firkins" <[EMAIL PROTECTED]> wrote: >>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 Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= --------------------------------------------------------------------- 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