API Commands
[All Commands]

Command: WorldHosting_Info_MySQL_Database



command WorldHosting_Info_MySQL_Database

Get informations about existing MySQL database

Input Parameters ($data):

string ssid Token from Login
string domain hosted domain name
string database name of the database

Output Responses:

string status ok | error
array data Details about your request
 
string database name of the database
array users list of users with permissions to this database
string username MySQL username
string permissions read/readwrite permissions of this user to this database

Sample:


<?php
$client 
= new SoapClient(
        
null
        array(
            
"location" => "https://PRODUCTION/cmd.php",
            
"uri" => "http://PRODUCTION/soap"
            
)
        );

$params = array ( 
    
"data" => array (
        
"login" => "demo",
        
"password" => "password",
    )
);

$response $client->__call("Login",$params);
$token $response["data"]["ssid"];

$params = array (
  
'data' => 
  array (
    
'ssid' => $token,
    
'domain' => 'domain.or.af',
    
'database' => 'mysqldb_a',
  ),
);

$response $client->__call("WorldHosting_Info_MySQL_Database",$params);
INPUT: Array ( [data] => Array ( [ssid] => 51aca4e95c12821b56a9045babc943e7 [domain] => domain.or.af [database] => mysqldb_a ) ) OUTPUT: Array ( [status] => ok [data] => Array ( [database] => mysqldb_a [users] => Array ( [0] => Array ( [username] => mysqlaccount_a [permissions] => readwrite ) ) ) )

API Manual - version from 2019-07-31 15:54:31