API Commands
[All Commands]

List_Web_Hosting_MySQL_Users


List of MySQL users.

Input:

string ssid token from Login
string webhosting Web Hosting code

Output:

string status ok | error
array users list of MySQL users
string username MySQL username
array ips list of additional IP addresses that are allowed access to the account

Example:


<?php

$client 
= new SoapClient(null, [
    
'location' => 'http://subreg.cz/soap/cmd.php',
    
'uri' => 'http://subreg.cz/soap'
]);

$login_input = [
    
'login' => 'demo',
    
'password' => 'demouser'
];

$login_output $client->__call('Login', ['data' => $login_input]);

$input = [
    
'ssid' => $login_output['data']['ssid'],
    
'webhosting' => 'NGHTFH'
];

$output $client->__call('List_Web_Hosting_MySQL_Users', ['data' => $input]);

print_r($input);
print_r($output);
$input: Array ( [ssid] => 51aca4e95c12821b56a9045babc943e7 [webhosting] => NGHTFH ) $output: Array ( [status] => ok [users] => Array ( [0] => Array ( [username] => mysqlaccount_a [ips] => Array ( [0] => 1.2.3.4 ) ) [1] => Array ( [username] => mysqlaccount_b [ips] => Array ( ) ) ) )

API Manual - version from 2023-05-12 12:15:50