mysql/createmysqluser

Description

Creates a new database user in an existing SPanel user account.

Info
If you want to create a database and user pair, you may want to check the mysql/createmysqldatabase API call which needs to be run after mysql/createmysqluser.

Parameters

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 name of the database user to be created.
password	string	Yes	The password that should be set to the new database user.
hostname	string	No	Default: localhost. If specified, the database user’s hostname will be set according to the value.

Example

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

$postData = [
  'token' => 'provided_auth_token',
  'accountuser' => 'spanelio',
  'action' => 'mysql/createmysqluser',
  'username' => 'dbuser'
  'password' => 'KExk80Ml5aG6M',
//'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 );Code language: PHP (php)

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

Output

{
    "result": "success",
    "data": {
        "msg": "The username spanelio_dbuser has been created successfully"
    }
}Code language: JSON / JSON with Comments (json)