If you're looking for a GUI client, I've been very happy with Navicat for MySQL (costs $$$ but for me totally worth it if a tool lets me work more effectively/efficiently).
I use navicat constantly working with both local mysql db's (mysql 5 on Leopard) and db's on various *nix boxes (mysql 4/5); only problem I've had is that it occasionally hangs trying to get connected to servers with large # of dbs (hundreds). The setup for a remote connection lets you use an SSH tunnel to the server (also SSL and HTTP, tho I haven't used those). Haven't tried an EC2-hosted server but as Guyren noted shouldn't matter unless there's some oddity about ssh. For key mgmt look into something like SSHKeychain ~ Deb On Sat, 1 Aug 2009 19:17:20 -0700, Unnsse Khan wrote: > > Fellow Rubyists, > > Am running a MySQL 5 database on a Red Hat Linux server hosted on an > Amazon EC2 cloud. > > Right now, I doing all my development (ruby, rails, mysql, etc.) > locally on an OS X Leopard based machine... > > What I am seeking is a MySQL client / tool which allows remotely > connecting to the Linux server through SSH and pem keys. > > What is the best OS X based tool / client to use to remotely connect > to an external MySQL database server on Linux? > > -Unnsse > > > --~--~---------~--~----~------------~-------~--~----~ SD Ruby mailing list [email protected] http://groups.google.com/group/sdruby -~----------~----~----~----~------~----~------~--~---
