# Create remote MySQL profile via SSH

This function uses SSH to create a profile to access a remote MySQL® server.

Endpoint: GET /remote_mysql_create_profile_via_ssh
Version: 11.134.0.5
Security: BasicAuth

## Query parameters:

  - `host` (any, required)
    The MySQL server's IP address or hostname.
    Example: "192.168.0.1"

  - `name` (string, required)
    The new profile's name.
    Example: "MyProfileSSH"

  - `port` (integer, required)
    The SSH server's port.
    Example: 22

  - `user` (string, required)
    The SSH username.
    Example: "SSHuser"

  - `cpcloud` (integer)
    Whether the remote database profile is a cPanel Cloud deployment.

*  — Is cPanel Cloud.
*  —  cPanel Cloud.
    Example: 1

  - `password` (string)
    The SSH username's password.



 You  specify either the  or the  parameter.
    Example: "12345luggage"

  - `root_escalation_method` (string)
    The escalation method to use to authenticate the account.



 This parameter is  if the user parameter's value is not .
    Enum: "sudo", "su"

  - `root_password` (string)
    The MySQL server's root user's password.



 This parameter is  if the  parameter's value is .
    Example: "username"

  - `sshkey_name` (string)
    The name of the SSH key.



 You  specify either the  or the  parameter.
    Example: "VinzClortho"

  - `sshkey_passphrase` (string)
    The SSH key's passphrase.



 This parameter is  if the  value is password-protected.
    Example: "Gozer"

## Response 200 fields (application/json):

  - `data` (object)

  - `data.profile_details` (object)
    An object containing the new profile's data.

  - `data.profile_details.cpcloud` (integer)
    Whether the remote database profile is a cPanel Cloud deployment.

*  — Is cPanel Cloud.
*  —  cPanel Cloud.
    Enum: 0, 1

  - `data.profile_details.mysql_host` (any)
    The MySQL server's IP address or hostname.
    Example: "192.168.0.1"

  - `data.profile_details.mysql_pass` (string)
    The MySQL server's password.
    Example: "12345luggage"

  - `data.profile_details.mysql_port` (integer)
    The MySQL server's port.
    Example: 3306

  - `data.profile_details.mysql_user` (string)
    The MySQL server's username.
    Example: "username"

  - `data.profile_details.setup_via` (string)
    description of the profile data.
    Example: "Created via SSH"

  - `data.profile_saved` (string)
    The new profile's name.
    Example: "MyProfileSSH"

  - `metadata` (object)

  - `metadata.command` (string)
    The method name called.
    Example: "remote_mysql_create_profile_via_ssh"

  - `metadata.reason` (string)
    The reason the API function failed when the  field is . This field may display a success message when a function succeeds.
    Example: "OK"

  - `metadata.result` (integer)
    *  — Success.
*  — Failed. Check the  field for more details.
    Enum: 0, 1

  - `metadata.version` (integer)
    The version of the API function.
    Example: 1