MySQL Administrator is not designed to work over a secure connection like ssh. By using ssh tunneling, you can connect to your remote MySQL servers from your workstation.
Download the MySQL Tools package.
Install the MySQL Tools package. On the Mac, just drag to Applications.
Create the Tunnel
To create the tunnel, open a shell (Terminal on the Mac) and run the following:
$ ssh -N -L3306:127.0.0.1:3306 username@remote_hostname
-N instructs ssh to run silently without creating a remote shell.
-L a:b:c instructs ssh to use port “a” on the local machine and map it (from the remote server’s viewpoint to port c on machine b).
Now you have a secure tunnel to the server.
Use the Right Hostname
If you run on a Un*x based workstation (i.e. Mac or Linux), when you run either the MySQL Administrator or the MySQL Query Browser, set the “Server Hostname” field to “127.0.0.1”.
If you skip this step you will receive the following error: