Skip to content

Connect to MySQL through the SSH tunnel

We take security seriously. Which is why we do not open port 3306 for external 3rd party connections, also we provide extra autentification password protection for the databases via the web (HTTPS only) through phpMyAdmin and Adminer tools.

We encourage the use of database management systems (DBMs) such as MySQL Workbench and SequelPro (both free) or TablePlus.

SSH tunnel parameters

In addition to a number of parameters that are in common with Standard TCP/IP connections, this connection method features a number of specialized parameters. These options are:

  • SSH Hostname -- the name of the SSH server. An optional port number can also be provided > Concatenate this string as server_IPv4_or_IPv6:SSH_port. For example for server IP 54.217.110.150 and port 22 this field should like as 54.217.110.150:22 or use separate if there fields like SSH hostname/IP and SSH port
  • SSH Username -- the name of the SSH user to use to make a connection. We suggest you to use separate users for different systems and developers.
  • SSH Password -- the SSH password
  • (optional) SSH Key File -- a path to the SSH key file in case you using the SSH key based autentification, if used password based autentification, leave this field empty.

Hint

MySQL Workbench does not accept default PuTTY keys directly. You can convert an existing PuTTY Private Key (ppk) file to OpenSSH format by using the PuTTY Key Generator (PuTTYGen) utility.

MySQL connection parameters

  • MySQL Hostname: 127.0.0.1
  • MySQL Server port: 3306
  • MySQL Username: Your project MySQL credentials (for CS-Cart and Multi-Vendor username located in /srv/projects/PROJECT_NAME/.mysql.yml file)
  • MySQL Password: Your project MySQL credentials (for CS-Cart and Multi-Vendor password located in /srv/projects/PROJECT_NAME/.mysql.yml file)

How to connect to MySQL through tools

MySQL Workbench

Sequel Pro

TablePlus