Scott Murphy

Setting up SSH to not have to enter your password every time is easy.

1. From the machine you want to connect from, create a private/public key.

air:~ user$ ssh-keygen -t rsa
Generating public/private rsa key pair.
Enter file in which to save the key (/Users/user/.ssh/id_rsa):
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in /Users/user/.ssh/id_rsa.
Your public key has been saved in /Users/user/.ssh/id_rsa.pub.
The key fingerprint is:
53:32:4f:7a:36:93:f8:89:06:8f:f6:9d:a2:bf:1d:e4 user@localhost

Here are the instructions on how to get MySQL Workbench up and running on Amazon EC2 after creating a "Getting Started on Fedora Core 8" AMI instance.

1. ssh into your instance forwarding port 3306
ssh -i ~/ec2key.pem root@your-ec2-ip-or-hostname
I normally put localhost instead of 127.0.0.1, but OSX gives me grief by
2. Install MySQL
yum install mysql-server
3. Configure MySQL to start on startup
ntsysv
check "mysqld"
4. Start up MySQL
/etc/init.d/mysqld start
5. Set root password
mysqladmin -u root password new-password-here

Now, Launch MySQL Workbench

Set up Cygwin & SSH Server on Windows 7

1a. Download Cygwin - http://www.cygwin.com/
1b. Run setup.exe
1c. Choose an install location. C:\cygwin is fine (I typically have it 1 more level up with all of my dev tools. Something like C:\dev\cygwin)
1d. Choose a package location C:\cygwin\packages (I like to keep everything together)
1e. For Internet Connection, Choose Direct Connection
1f. For Download Site, Pick an http one that looks fast or close.
1g. For Package Selection, select at least the following:
Net > OpenSSH
Net > OpenSSL