Does anyone else have problems with PhpMyAdmin where it lists ALL the databases, but does not allow access to them? Its like someone logins and goes ot phpmyadmin and it shows all the databases but it only allows them to access their own.. How can I get it to only show their databases?

I am currently running Red Hat Enterprise Linux ES with WHM/CPanel 10.0.0 (RELEASE)

If you have root access to the database, replace the login details in the PHPMyAdmin conf files with that of your root access account. Then once you're in, you should be able to see/change database permissions.
Good luck,
~Equinox

Umm, it was actually a bug while upgrading to version 4.0 or above (MySQL)

If anyone else is having this problem just run the command "mysql_fix_privilege_tables" if you get a denied error run "nano -w /usr/bin/mysql_fix_privilege_tables" then find:

root_password=""
host="localhost"
user="root"
port=""
socket=""

You just need to fill in the "password" section then save and run it again... Then everything works