This complicated procedure allows you to: Then it uses this tunnel to connect via a standard connection from the SSH host to the MySQL host. If you use a SSH connection, Sequel Pro first creates a SSH tunnel to the SSH host. sshd is a process that accepts SSH connections, and mysqld is the MySQL server process. The SSH host can be the same as the MySQL host, but it doesn't have to be.įigure 1: An SSH connection can be used to connect through a firewall (if the firewall allows SSH tunnels). While a standard connection involves only two hosts (your computer and the host on which the MySQL server is running), a SSH connection involves a third host, the SSH host. A SSH connection is actually not really a different kind of connection, but rather a standard connection made through a SSH tunnel.
You can use a SSH connection to circumvent some of the restrictions of standard conections. To use this connection type: SSH connections A standard connection in Sequel Pro is a connection over the local network or the internet. Standard connections are the simplest method to connect to a MySQL server. SSL connections are not yet supported by Sequel Pro, but are planned. Connection Types for connecting to a remote hostĪt the moment, Sequel Pro supports two methods for connecting to remote MySQL servers:
You may also see the page Getting Connected.
Ssh tunnel mysql how to#
This page explains how to connect to a MySQL Server running on a different computer than Sequel Pro.
0 kommentar(er)
