What do you guys recommend for me to use for mysql administration? It would need multiple user levels. Include a link if possible.

go to hotscripts.com and download phpmyadmin

does it support multiple users? can each user only see his/her databases?

Yep :)

I have installed it on my home server and can't figure out how to make users only see there databases and how you actually log in to phpmyadmin with any user besides root and ODBC.

Any hepl is great

The key to allowing a user to see only their database is too give their MySQL user account permissions that allow access to just that database.

To accomplish this I first add a database with their username, and then use the following SQL to create their account and give them permission to their database:

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
ON <database name>.*
TO <username>@localhost identified by '<password>';

Once that's done and they login with their new username and password all they see is their own database and are also not permitted access to all the "restart mysql", etc. commands.