Self Help Documentation
< All Topics

mysql/createmysqluser

PostedFebruary 24, 2022
UpdatedApril 25, 2023

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

FieldTypeRequiredDescription
tokenstringYesAuthorizing API token – check API Basics for more information.
accountuserstringYesThe SPanel user account that is being managed or viewed.
actionstringYesThe category and function being executed.
usernamestringYesThe name of the database user to be created.
passwordstringYesThe password that should be set to the new database user.
hostnamestringNoDefault: localhost. If specified, the database user’s hostname will be set according to the value.

Example

PHP
PHP
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
$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

JSON
PHP
1
2
3
4
5
6
{
    "result": "success",
    "data": {
        "msg": "The username spanelio_dbuser has been created successfully"
    }
}
Table of Contents