SiteHost API

/cloud/db/grant/delete

Removes all grants from an existing database user.

Form Parameters

Code Samples

var xmlHttp = new XMLHttpRequest();
xmlHttp.open("POST", "https://api.sitehost.nz/1.5/cloud/db/grant/delete.json", false);

var data = new FormData(); 
data.append("apikey", "your_key_here");
data.append("client_id", "1");
data.append("server_name", "ch-servername");
data.append("mysql_host", "mysql8");
data.append("database", "dbname");
data.append("username", "dbuser");

xmlHttp.send(data);

var response = xmlHttp.responseText;

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, "https://api.sitehost.nz/1.5/cloud/db/grant/delete.json");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_POST, 1);
$body = array(
    'apikey' => 'your_key_here',
    'client_id' => 1,
    'server_name' => 'ch-servername',
    'mysql_host' => 'mysql8',
    'database' => 'dbname',
    'username' => 'dbuser',
);
curl_setopt($ch, CURLOPT_POSTFIELDS, $body);

$response = curl_exec($ch);
$status = curl_getinfo($ch, CURLINFO_HTTP_CODE);
curl_close($ch);

require 'net/http'
require 'uri'

uri = URI.parse("https://api.sitehost.nz/1.5/cloud/db/grant/delete.json")
http = Net::HTTP.new(uri.host, uri.port)
request = Net::HTTP::Post.new(uri.request_uri)

body = {"apikey" => "your_key_here", 
    "client_id" => 1,
    "server_name" => "ch-servername",
    "mysql_host" => "mysql8",
    "database" => "dbname",
    "username" => "dbuser",
}
request.set_form_data(body)

response = http.request(request)

import requests
from collections import OrderedDict

uri = 'https://api.sitehost.nz/1.5/cloud/db/grant/delete.json'

# We need ordered dictionary because parameters have to be in the right order.
# Refer to Developer Notes for more information.
body = OrderedDict()

body['apikey'] = 'your_key_here'
body['client_id'] = 1
body['server_name'] = 'ch-servername'
body['mysql_host'] = 'mysql8'
body['database'] = 'dbname'
body['username'] = 'dbuser'

response = requests.post(uri, data=body)

Response