Sequel Pro — MySQL database management app for Mac OS X
Update: Found an even nicer application called Querious! I like it even better than Sequel Pro. – Check out the review on TheAppleBlog.
Querious feels much more native than Sequel Pro. For example: when your browsing the list of tables and you want to rename one-simply hit Return on your keyboard and the name is editable. Just like in a lot of other Mac applications. The overall quality feels really good and yes, I am a sucker of eyecandy and UIs (ONE of the reasons I own an iPhone! 
).
ORIGINAL POST
Why did I not find this before? This has made using MySQL so much easier! Plus, it’s FREE! 
Edit: I successfully renamed a bunch of tables to add prefixes to them and even moved a huge database, both things would have been completely nearly impossible in phpMyAdmin!