mysql/revokeuseraccess

PostedMarch 2, 2022

UpdatedApril 26, 2023

Description

Removes access for an existing database user from an existing database.

Field	Type	Required	Description
token	string	Yes	Authorizing API token – check API Basics for more information.
accountuser	string	Yes	The SPanel user account that is being managed or viewed.
action	string	Yes	The category and function being executed.
database	string	Yes	The name of the database to be used.
username	string	Yes	The username of the database user to be used.
hostname	string	No	Default: localhost. If specified, the database user’s hostname will be set according to the value.

$endpointUrl = 'https://123.123.123.123/spanel/api.php';

$postData = [

'token' => 'provided_auth_token',

'accountuser' => 'spanelio',

'action' => 'mysql/revokeuseraccess',

'database' => 'db',

'username' => 'dbuser',

//'hostname' => '123.123.123.123'

];

$ch = curl_init();

curl_setopt( $ch, CURLOPT_URL, $endpointUrl);

curl_setopt( $ch, CURLOPT_RETURNTRANSFER, 1);

curl_setopt( $ch, CURLOPT_POST, true);

curl_setopt( $ch, CURLOPT_POSTFIELDS, http_build_query($postData));

curl_setopt( $ch, CURLOPT_SSL_VERIFYPEER, false);

curl_setopt( $ch, CURLOPT_SSL_VERIFYHOST, false);

$jsonOutput = curl_exec( $ch );

You can find more information about the Endpoint URL in our API Basics article.

{

"result": "success",

"data": {

"msg": "User access revoked successfully"

}