API Commands
[All Commands]

Update_Web_Hosting_MySQL_Database


Modify MySQL database configuration.

Input:

string ssid token from Login
string webhosting Web Hosting code
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://regtons.com/soap/cmd.php',
    
'uri' => 'http://regtons.com/soap'
]);

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

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

$input = [
    
'ssid' => $login_output['data']['ssid'],
    
'webhosting' => 'NGHTFH',
    
'database' => 'mysqldb_a',
    
'users' => [
        [
            
'username' => 'mysqlaccount_a',
            
'permissions' => 'readwrite'
        
]
    ]
];

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

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

API Manual - version from 2020-06-03 13:27:22