I've been running into a lot of shortcomings with phpMyAdmin, especially when it comes to anything Foreign Key related. Imports and Exports can be shady, and working with large amounts of data is a chore.
I love that it runs in a web browser so that I'm able to run it on any host, but I've been moving from shared environments to dedicated hardware and have the ability to access MySQL remotely now.
Can anyone recommend the next level of MySQL administration once a developer has graduated from PMA? Is there an amazing GUI tool, or should I finally memorize those
CREATE TABLE statements and use the command line?
I've been a PMA user since 2004.