Ssh Manual
This connection method enables MySQL Workbench to connect to MySQL Server using TCP/IP over an SSH connection.
Parameters Tab
Specifies a file from which the user's RSA or DSA authentication identity is read. The default is /.ssh/identity for protocol version 1, and /.ssh/idrsa and /.ssh/iddsa for protocol version 2. Additionally, any identities represented by the authentication agent will be used for authentication. SSH is built into Linux distributions and Mac OS, and is an optional feature in Windows 10. For older Windows versions and mobile devices, third-party SSH clients are available. See the following guides for using SSH with the OS on your computer or device. After loading a private key, ssh-add will try to load corresponding certificate information from the filename obtained by appending -cert.pub to the name of the private key file. Alternative file names can be given on the command line. If any file requires a passphrase, ssh-add. Search the world's information, including webpages, images, videos and more. Google has many special features to help you find exactly what you're looking for.
Ssh Manually Add Known_hosts
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. For example,
localhost:22.SSH Username: The name of the SSH user to use to make a connection.
SSH Password: The SSH password. It is recommended that an SSH key file is also used.
SSH Key File: A path to the SSH key file.
MySQL Workbench does not accept default PuTTY keys directly. However, you can convert an existing PuTTY Private Key (ppk) file to OpenSSH format using the PuTTY Key Generator (PuTTYGen) utility.
If a remote host is missing from the system's list of known hosts, a prompt requires you to confirm the host's fingerprint before storing it. If your stored host fingerprint is different than the host's current fingerprint, then an error is generated and you will be required to handle the discrepancy from outside of MySQL Workbench before creating the connection.
On Linux and macOS, SSH host fingerprints are stored in ~/.ssh/known_hosts. On Microsoft Windows, they are stored in a file created by MySQL Workbench under the user's folder, such as C:Users The path to the SSH known hosts file is configurable (see Section 3.2.6, “SSH Preferences”). username.sshknown_hosts.
The following figure shows the SSH connection settings.
Ssh Manual
Figure 5.15 Manage Server Connections - Standard TCP/IP over SSH Parameters
SSL Tab
The SSL options for this connection method are the same as the options described in Section 5.3.1, “Standard TCP/IP Connection Method”.
Ssh Manual Linux
Ssh Manually Add Public Key
Advanced Tab
Openssh Options
The advanced options for this connection method are the same as the options described in Section 5.3.1, “Standard TCP/IP Connection Method”, except the Timeout option does not apply.