apps I use to get the job done
When I access a MySQL database to add or manage databases and tables, I prefer using a MySQL tool rather than the command line. The best tool for this out there for the price of free is SequelPro (formerly Cocoa MySQL). SQL has a more intuitive user interface than phpMyAdmin, and makes managing data simple and quick. I can connect to local or remote databases, save favorites, run SQL queries and manage table info like columns, encoding and size.