API Commands
[All Commands]

Update_World_Hosting_MySQL_Database


Modify MySQL database configuration.

Input:

string ssid token from Login
string domain World Hosting domain name
string database name of the database
array users list of users with access to this database (optional)
string username MySQL username
string permissions read/readwrite permissions of this user to this database

Output:

string status ok | error

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'],
    
'domain' => 'domain.or.af',
    
'database' => 'mysqldb_a',
    
'users' => [
        [
            
'username' => 'mysqlaccount_a',
            
'permissions' => 'readwrite'
        
]
    ]
];

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

print_r($input);
print_r($output);
$input: Array ( [ssid] => 51aca4e95c12821b56a9045babc943e7 [domain] => domain.or.af [database] => mysqldb_a [users] => Array ( [0] => Array ( [username] => mysqlaccount_a [permissions] => readwrite ) ) ) $output: Array ( [status] => ok )

API Manual - version from 2020-10-08 23:58:51