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
22this field should like as
220.127.116.11:22or 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.
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:
- MySQL Server port:
- MySQL Username: Your project MySQL credentials (for CS-Cart and Multi-Vendor username located in
- MySQL Password: Your project MySQL credentials (for CS-Cart and Multi-Vendor password located in