< All Topics



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

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.


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.


$endpointUrl = '';

$postData = [
  'token' => 'provided_auth_token',
  'accountuser' => 'spanelio',
  'action' => 'mysql/createmysqluser',
  'username' => 'dbuser'
  'password' => 'KExk80Ml5aG6M',
//'hostname' => ''

$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": "The username spanelio_dbuser has been created successfully"
Previous mysql/listusers
Next mysql/deletemysqluser
Table of Contents