SiteHost API: /cloud/db/user/get

/cloud /db /user /get

GET https://api.sitehost.nz/1.2/cloud/db/user/get.json

Returns information about a database user.

Query Parameters

Parameter	Type	Required	Description
client_id	integer	Yes	The ID for the client that the database user belongs to.Example: 1
server_name	string	Yes	The server where the database user resides.Example: ch-servername
mysql_host	string	Yes	The MySQL Integrated Container where the database user resides. Valid options (if they are running) are mysql56, mysql57, and mysql8.Example: mysql57
username	string	Yes	The username of the database user.Example: dbuser

Code Samples

JavaScript PHP Rails Python

var xmlHttp = new XMLHttpRequest();
xmlHttp.open("GET", "https://api.sitehost.nz/1.2/cloud/db/user/get.json?apikey=your_key_here&client_id=1&server_name=ch-servername&mysql_host=mysql57&username=dbuser", false);

xmlHttp.send();

var response = xmlHttp.responseText;

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, "https://api.sitehost.nz/1.2/cloud/db/user/get.json?apikey=your_key_here&client_id=1&server_name=ch-servername&mysql_host=mysql57&username=dbuser");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
$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.2/cloud/db/user/get.json?apikey=your_key_here&client_id=1&server_name=ch-servername&mysql_host=mysql57&username=dbuser")
http = Net::HTTP.new(uri.host, uri.port)
request = Net::HTTP::Get.new(uri.request_uri)

response = http.request(request)

import requests

uri = 'https://api.sitehost.nz/1.2/cloud/db/user/get.json?apikey=your_key_here&client_id=1&server_name=ch-servername&mysql_host=mysql57&username=dbuser'

response = requests.get(uri)

Response

200:

application/json

{
    "return": {
        "username": "username",
        "password": "",
        "mysql_host": "mysql8",
        "server_id": "1",
        "client_id": "1",
        "pending": null,
        "is_missing": "0",
        "date_added": "0000-00-00 00:00:00",
        "date_updated": "2020-10-21 15:48:48",
        "server_name": "ch-servername",
        "server_label": "Server Label",
        "grants": [
            {
                "db_name": "db1",
                "username": "username",
                "host": "%",
                "mysql_host": "mysql8",
                "grants": [
                    "create view",
                    "select"
                ],
                "pending": null,
                "is_missing": "0",
                "date_added": "0000-00-00 00:00:00",
                "date_updated": "2020-10-21 15:48:48"
            }
        ]
    },
    "msg": "Successful",
    "status": true
}