/cloud/db/user/get
GET https://api.sitehost.nz/1.3/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 Pythonvar xmlHttp = new XMLHttpRequest();
xmlHttp.open("GET", "https://api.sitehost.nz/1.3/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.3/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.3/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.3/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",
"server": "ch-myserver"
},
"msg": "Successful",
"status": true
}
"return": {
"username": "username",
"server": "ch-myserver"
},
"msg": "Successful",
"status": true
}