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 );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"
}
}