Connecting to a Compute Node Through Secure Shell (SSH)

To gain local access the tools, utilities and other resources on a compute node associated with MySQL Cloud Service, you use Secure Shell (SSH) client software to establish a secure connection and log in as the user opc. Once logged in as opc, you can switch to the oracle user.

Several SSH clients are freely available. The following sections show how to use SSH clients on UNIX, UNIX-like and Windows platforms to connect to a compute node associated with MySQL Cloud Service.

Connecting to a Compute Node Using the ssh Utility on UNIX and UNIX-Like Platforms

UNIX and UNIX-like platforms (including Solaris and Linux) include the ssh utility, an SSH client.

Before You Begin

Before you use the ssh utility to connect to a compute node, you need the following:

The IP address of the compute node

The IP address of a compute node associated with a database deployment on MySQL Cloud Service is listed on the MySQL Cloud Service Overview page. For instructions to display this page, see Viewing Detailed Information for a MySQL Server Deployment.
The SSH private key file that matches the public key associated with the deployment.

Procedure

To connect to a compute node using the ssh utility on UNIX and UNIX-like platforms:

In a command shell, set the file permissions of the private key file so that only you have access to it:
```
$ chmod 600 private-key-file
```
private-key-file is the path to the SSH private key file that matches the public key that is associated with the deployment.
Run the ssh utility:
```
$ ssh -i private-key-file user-name@node-ip-address
```
where:
- private-key-file is the path to the SSH private key file.
- user-name is the opc user
  - Connect as the user opc to perform operations that require root access to the compute node, this user can use the sudo su oracle command to use MySQL from the command prompt..
- node-ip-address is the IP address of the compute node in x.x.x.x format.
If this is the first time you are connecting to the compute node, the ssh utility prompts you to confirm the public key. In response to the prompt, enter yes.

Connecting to a Compute Node Using the PuTTY Program on Windows

PuTTY is a freely available SSH client program for Windows.

Before You Begin

Before you use the PuTTY program to connect to a compute node, you need the following:

The IP address of the compute node

The IP address of a compute node associated with a database deployment on MySQL Cloud Service is listed on the MySQL Cloud Service Overview page. For instructions to display this page, see Viewing Detailed Information for a MySQL Server Deployment.
The SSH private key file that matches the public key associated with the deployment. This private key file must of the PuTTY .ppk format. If the private key file was originally created on the Linux platform, you can use the PuTTYgen program to convert it to the .ppk format.

Procedure

To connect to a compute node using the PuTTY program on Windows:

Download and install PuTTY.

To download PuTTY, go to http://www.putty.org/ and click the You can download PuTTY here link.
Run the PuTTY program.

The PuTTY Configuration window is displayed, showing the Session panel.
In Host Name (or IP address) box, enter the IP address of the compute node.
Confirm that the Connection type option is set to SSH.
In the Category tree, expand Connection if necessary and then click Data.

The Data panel is displayed.
In Auto-login username box, enter the opc user to connect as.
Confirm that the When username is not specified option is set to Prompt.
In the Category tree, expand SSH and then click Auth.

The Auth panel is displayed.
Click the Browse button next to the Private key file for authentication box. Then, in the Select private key file window, navigate to and open the private key file that matches the public key that is associated with the deployment .
In the Category tree, click Session.

The Session panel is displayed.
In the Saved Sessions box, enter a name for this connection configuration. Then, click Save.
Click Open to open the connection.

The PuTTY Configuration window is closed and the PuTTY window is displayed.
If this is the first time you are connecting to the VM, the PuTTY Security Alert window is displayed, prompting you to confirm the public key. Click Yes to continue connecting.