phpmyadmin - display databases only for owning users

[Drew Decker]

Hello All,

This is a phpMyAdmin question, however, it may be a mySQL issue that I am experiencing. You guys can tell me or direct me to the proper area (configuration). I have phpMyAdmin installed on a server and I have different users running different databases. For example, I have 1 user that has only one database, another user that has two databases, and a third user that has about 15 databases.

My problem is when I login to phpmyadmin with a user that only has access to one database, can see all the databases in the left pane of the window (where all the databases are listed). Just to test something, I tried doing something to the other database and I was given an access denied. So, the security is there, but the fact that I can see the other databases is 1) annoying 2) cluttered, and 3) not that secure if run in a multi-hosting environment (currrently this server just runs my main site so no actual customers are on it for shared hosting or the like).

While this could be a phpMyAdmin issue, I'd still like someone to let me know how to either fix this or direct me somewhere I can figure it out.

Thanks in advanced,
Drew