i've got two servers that run cPanel, PHP, and phpMyAdmin. server 2 runs newer versions of php, phpMyAdmin, mysql, and i think cPanel as well.
with server 1 i can log in directly to a websites phpMyAdmin using the username and password for the website acount in cPanel and it can get in and do everything i need to even thought i'm not logged in as a particular user registered for that database.
with server 2 i can log in that way but it won't show me any databases. the only way i can get it is if i go to cPanel for that account log in as that user then go to the phpMyAdmin link. just way too time consuming when all i want to do is go into an account and check something real quick.
i've also tried using a local version of phpMyAdmin to log into the servers mysql which works but is about 5x slower than if i'm running it directly on the server.
i figure it has to be something with the login security settings in the config file, but our server guys are being douches about it even though its our dedicated server. any ideas for a solution?
I've had a similar problem before and I think it was due to an error in the version of phpmyadmin I was using, or something. Not really sure, however, I was able to view everything correctly in my phpmyadmin installation by switching browsers from firefox to internet explorer. Try this to see if anything changes, and if not we'll work someone out. :)