I used to use cocoa mysql for my mac but can no longer find a free version. I'm using the beta of mysql workbench, but it's irritating that i can't copy and paste from a result set, plus i need more key board short cuts and don't know how to write java. Any other suggestions for free or inexpensive GUI for Mac? I do a lot of analysis of data in other programs (Excel, R) and need more flexibility.
Try navicat. Not sure if it has the copy and paste functionality that you want. http://www.navicat.com/en/download/download.html
Download HeidiSQL. It's a free app. There is a linux version that runs with wine that works on Mac OS X . It may work for you. It is filled with features. You can copy and paste and export result sets in many formats.