MySQL user permission

defining user perms

[Nd4Spd]

Greetings,

I am running mySQL v. 3.23.49 and currently have about 5 databases in it. Now, my question is this: no matter what users logs in (ie: user: 'spider' to view the 'spider' database) can also see all the other data bases in mysql. I know this cannot be correct and am wondering what I can do to fix this. Each user has their own perms for what they can do to the tables. Root, of course, can see and do everything, but spider can "see" and view all data because the type database it is, requires that it can do so. But it can do so on ALL databases in mysql.
I'm also running phpMyAdmin v. 2.2.3. Using phpMyAdmin and different browsers (was trying to narrow it all down) I can still "see" all the databases in mysql.

Any help in resolving this would be greatly appreciated as other users do not need access to databases they are not authorized for.

Aaron

[Nd4Spd]

Success! I have figured it out. It was a matter of privliges that needed to be defined and revoked. Privilges were in place for modifying 'ALL' databases, AND the databases the users actually needed. By removing the privilges to 'ALL', it is working as it should.

Aaron