homehome previousprevious nextnext
 
Password Authentication

Using this mode, SSH is almost identical to the program telnet. When you make a connection, you are asked for your password. You type it in and you are either logged in or denied. Your password is first encrypted and then sent over the network and then decrypted at the remote host. This is the mode that most users will be encouraged to use, as it requires no additional setup or configuration.

The following instruction guides you through the process of configuring a SSH connection using Password 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 and Password.

  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

    Password
    It is a Linux user password.

  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:
Public Key Authentication

 

Copyright 1999 - 2007. PremiumSoft TM CyberTech Ltd All rights reserved
MySQL TM is a trademark of MySQL AB in the United States and other countries.