mysql/changeuserpass

PostedMarch 2, 2022

UpdatedApril 26, 2023

Description

Changes the password of an existing database user.

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.
username	string	Yes	The username of the database user to be used.
password	string	Yes	The new password to be set.
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/changeuserpass',

'username' => 'dbuser',

'password' => 'NewUserPassword',

//'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": "Password updated successfully"

}