API Commands
[All Commands]

Command: WorldHosting_List_MySQL_Databases



command WorldHosting_List_MySQL_Databases

Get list of existing MySQL databases

Input Parameters ($data):

string ssid Token from Login
string domain hosted domain name

Output Responses:

string status ok | error
array data Details about your request
 
array databases list of databases
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',
  ),
);

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

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