phpMyadmin databases are viewable to all

Hi I am running phpMyAdmin 2.6.4-pl1
with MySQL 4.0.20-standard on RedHat Linux 9.0

Almost everything works great except that any of the users can see the all of the database names when the login they can only access their own database but all of the others show up as databases but with a - where the number of tables usually is displayed.

In my prior version of phpmyadmin and mysql and redhat linux, not sure of the versions but I can find out if it is important, this was not the case. When a given user logged in they could only see their own database to which they would have complete access to. This is how I want to set my current version to be like.

Since my database names are based on my customers I do not want my customers to know about my other customers as it could lead to possible issues.

What are the settings I need to look at to change how this new version works

Thanks
Jeff

If there are any additional settings you need for information let me know and I can try to get them

I'm not sure how phpMyAdmin is doing it, but you may want to not give the users SHOW DATABASES permissions. You can also restrict PMA to only use one/a few databases by entering them in the right place in the config.inc.php file.

--Simon

I've been playing with this a bit lately myself and this is what I have: database names are prefixed with usernames or domain names, like foo_com_database. I then create a MySQL user, foo_com and give them permissions on foo_com_% (% is a wildcard). You then set up phpMyAdmin to use HTTP auth or cookie auth so that the user logs in with his or her username. The result is that user foo_com only sees foo_com_* databases and can only (or should only be able to) create databases that start with foo_com_ (provided you let them create databases via phpMyAdmin).

Simon-Where would I set the SHOW DATABASES permission is it in one of the mysql tables.
-----------------------------

Jeremy- In my old setup and current one a user had a domain name of xyzbiz.com there database would be called xyzbiz and when they logged on to phpMyAdmin the xyzbiz database would be the only one visible if I looged on as the overall owner of the server or I am assuming admin I would get a drop down where I could select any of the databases and the subsequentially any of the tables and work on them as needed from one spot(my admin level). On the new setup EVERYONE gets the dropdown to select databases but only the database of the specific usere will show any tables that exist all other databases show the hyphen and if they are clicked on an error message pops up and says that the given user does not have the correct permission to access ths table.

The table names were derived directly from the username of the account unless the username was too long and I could access them directly in linux through SSH or via phpMyAdmin using the exact same name.

I also have many databases already created along with db based web pages so I do not think your methodology would
benefit me currently Thanks you for your input though if you have any other ideas I will be glad to take a look at them.
-----------------------------