I am on a mac os 10 and I want to connect a local copy of a drupal site to a remote mysql data. I can access the server using ssh as root, the database is setup and running, how can I connect to the database on the remote server using a ssh tunnel or similar? I don't want to have a local copy of the database running for development.
ssh using this command
and leave that open. You should then be able to connect to the remote mysql server as if it were running on the local machine. The -L parameter on ssh listens on that port on the local machine and forwards all traffic to it across the ssh connction to the host and port specified at the other end.