Cocoa MySQL

I use a combination of PHPMyAdmin and Cocoa MySQL when I do my local MySQL database work. Cocoa MySQL has many features PHPMyAdmin doesn't, and PHPMyAdmin fills in some Cocoa voids. The interface is intuitive and fast. It lets me access my data via links, dropdowns and direct SQL queries (as it should). It's supposed to connect to local as well as remote databases, but I haven't had much luck with it as a remote MySQL tool. But that's where PHPMyAdmin fills in the void.

Update: I'm giving Sequel Pro by MJ Media a try. Sequel Pro is a port of Cocoa MySQL that's updated for a much more Leopard-like experience. It does all that CocoaMySQL does, and is being actively developed, which is great. So far, I'm loving it. Read more of my thoughts on Sequel Pro here.

Screenshots:

Table field listing

Table data listing

Tips:

1. Use it for remote access to your MySQL databases
   In most cases, though, you'll need to request specific access from your host. Your host should be able to provide access to the databases from your IP. It's WAY faster than using phpMyAdmin, which in my experience, most Apache hosts provide.

	nery	Jun 20, 2005
	I found that this has problems running on Tiger. Anyone else have that experience?
	jasonk - jasonk at jasonkenison dot com	Jun 20, 2005
	I haven't experienced any problems with CocoaMySQL on Tiger (on either 10.4.0 or 10.4.1). What kind of problems are you experiencing and/or have heard of?
	Jonathan	Jul 22, 2005
	[link]
	jasonk - jasonk at jasonkenison dot com	Jul 22, 2005
	When you set up your local account in Cocoa MySQL, do you set your host as "localhost"? That's how mine's set up and it *does* work to connect locally. To connect remotely (meaning a server other than my own), however, I have to have a special login that allows remote access from my IP address. You can usually discuss this with your host to set this up. Otherwise, there's always command line in terminal
	jasonk - jasonk at jasonkenison dot com	Jul 22, 2005
	Ah, a MySQL issue. I haven't upgraded from 3.23 (bundled with Marc Liyanage's PHP/MySQL installation packages for OS X: http://www.entropy.ch/software/macosx/). Guess I'll hold off on the version upgrade until CocoaMySQL is ready.
	Jonathan	Jul 22, 2005
	You can get a patched version of CocoaMySQL that does work with MySQL 4.1 (see link above). I just downloaded the patched version, and it does work.
	cocoa mysql on tiger Qleyo - ebi dot atawodi at gmail dot com	Feb 5, 2006
	I had problems too, i was creating tables and they never showed or let me add fields. I just downloaded a version off http://theonline.org/cocoamysql/ after following the links above and it works fine Thanks!
	Anonymous	Jul 4, 2006
	thanks for the note about the newer version. I needed it to work with the newer sql pkgs (5.0).
	Re: Anonymous jasonk - jasonk at jasonkenison dot com	Jul 5, 2006
	I guess I'm a bit behind, haven't tried CocoaMySQL with anything higher than MySQL 3.23.49, seems to work fine for my needs. I'm sorry, but don't know what alternative to recommend.
	Gordon Royle - gordon at csse dot uwa dot edu dot au	Jul 25, 2006
	I tried CocoaMySQL as well (MySQL 5.0.22, Tiger 10.4.7) and I'm having some problems.. in your nice "table field listing" screenshot it shows the fields with their proper types (INT, CHAR etc). I can connect fine, but when I select a table, it takes a while and then comes back with "types" called things like .. What is happening?
	Re: Gordon Royle jasonk - jasonk at jasonkenison dot com	Jul 25, 2006
	Unfortunately CocoaMySQL works with MySQL vs. 4.1 or less only... the problem you're having is only a MySQL version incompatibility. See CocoaMySQL's FAQ for more on the subject. Try Navicat for some more robust features and MySQL 5+ compatibility.
	Re: Re: Gordon Royle jasonk - jasonk at jasonkenison dot com	Aug 31, 2008
	Scratch that... Sequel Pro is great, highly recommended. See a link in the updated copy above.
	Anonymous	Nov 5, 2009
	thnks dude

 
↑ Top