Public-key Authentication is based on the use of digital signatures and provides the best authentication security.

For Public Key Authentication to work four things are needed:

• the remote server(s) you are connecting must have your public key.
• the local client you are connecting from must have your private key.
• the remote server must be configured to allow you to login using your public key.
• the local client must be configured to use your private key while logging into remote server.

The following instruction guides you through the process of configuring a SSH connection using Public Key Authentication. To successfully establish a SSH connection , set the SSH connection properties in the corresponding boxes: Host name/IP address, Port number, User name, Authentication Method, Private Key and Passphrase.

1. Click or choose File -> New Connection to set up the Connection Properties.
2. Select the SSH tab and enable Use SSH Tunnel.
3. Fill in the required information:
   
   Host name/IP address
   A host where SSH server is activated.
   
   Port
   A port where SSH server is activated, by default it is 22.
   
   User name
   A user on Linux machine. (It is a Linux user. It is not a user of MySQL Server.)
   
   Authentication Method
   Choose between Password Authentication and Public Key Authentication
   
   Private Key
   It is used together with your public key. The private key should be readable only by you.
   
   Passphrase
   A passphrase is exactly like a password, except that it applies to the keys you are generating and not an account. The passphrase be any length under 1024 characters.
   
   

   

4. Navicat MySQL host name at the General Settings page should be set relatively to the SSH server in this case. For example: host_of_mysqldatabase shown below is the host address, which provided by your hosting company, of your remote MySQL database.
   
   Connection Name
   A friendly name to best describe your connection.
   
   Host name/IP address
   A host where MySQL Server is located in point of view SSH server. If SSH and MySQL Server are on the same machine, it is equal to SSH Host, or may be 'localhost'.
   
   Port
   A port of MySQL Server on Remote Host, by default it is 3306.
   
   User name
   It is a MySQL Server user name.
   
   Password
   It is a password of the MySQL user.
   

   

See also:
Advanced Settings

Related topics:
Password Authentication