UAPI Functions - Mysql::add_host

Description

This function authorizes a remote MySQL® host to access the account's databases.

Example


 cPanel or Webmail Session URL

https://hostname.example.com:2083/cpsess##########/execute/Mysql/add_host?host=remote.example.com

 LiveAPI PHP Class

$cpanel new CPANEL(); // Connect to cPanel - only do this once.
  
// Authorize a remote host.
$add_host $cpanel->uapi(
    'Mysql''add_host',
    array(
        'host'       => 'remote.example.com',
    )
);

 LiveAPI Perl Module

my $cpliveapi = Cpanel::LiveAPI->new(); # Connect to cPanel - only do this once.
  
# Authorize a remote host.
my $add_host $cpliveapi->uapi(
    'Mysql''add_host',
    {
        'host'       => 'remote.example.com',
    }
);

 cPanel Template Toolkit

<!-- Authorize a remote host. -->
[% execute('Mysql', 'add_host', { host => 'remote.example.com' } ) %]

 Command Line

uapi --user=username Mysql add_host host=remote.example.com

 

Notes:

  • You must URI-encode values.
  • username represents your account-level username.

 Output (JSON)

{
  "messages": null,
  "errors": null,
  "status": 1,
  "metadata": {
      
  },
  "data": null
}

 

Note:

Use cPanel's API Shell interface (Home >> Advanced >> API Shell) to directly test cPanel API calls.

 

Parameters

 Parameter 

Type

Description

Possible values

Example

host

 string 

Required

 The remote MySQL server's hostname. 

A remote MySQL hostname or IP address.

Note:

You may use the following IP address formats:

  • 192.168.1.6 — IP address.
  • 192.168.%.% — Range with the percent (%) symbol as a wildcard.
  • 192.168.0.0/16 — Range in CIDR format.

 

 remote.example.com 

 

Returns

This function only returns metadata.

  • 7 Users Found This Useful
Was this answer helpful?

Related Articles

The cPanel Interface

For  cPanel  &  WHM  version  58 Overview The cPanel interface is...

User Preferences

For cPanel & WHM version 58 Overview This document outlines how to access your cPanel...

Manage External Authentications

For cPanel & WHM version 58 Overview Manage credentials Additional documentation...

What is cPanelID?

In This Article:  Overview ServicesHow to get a cPanelID cPanelID External...

Guide to cPanel Interface Customization - cPanel Style Development

Introduction You can develop custom styles that modify the appearance of the cPanel interface....