include 'xmlapi-php-master/xmlapi.php';
$ip = 'IP_ADDRESS'; #IP of your cPanel/WHM server
$user = 'cpanel_username'; #cpanel username
$pass = 'password_hosting'; #password of your cPanel user
$xmlapi = new xmlapi($ip);
$xmlapi->password_auth($user,$pass);
$xmlapi->set_port(2083);
$xmlapi->set_output("xml");
$xmlapi->set_debug(1);
$dominio='domain.com';
print $xmlapi->api1_query($user, "Mysql", "adddb", 'db_name');
//create user
print $xmlapi->api1_query($user, "Mysql", "adduser", array(
'user' => 'db_user',
'pass'=>'some_p@assw0rd'));
//add user to database
$xmlapi->api1_query($user, "Mysql", "adduserdb", array(
'user'=>'cpanel_username_db_user',
'db' => 'cpanel_username_db_name',
'SELECT INSERT UPDATE CREATE DELETE ALTER DROP'));
i've got this error message
"..Mysqladdusereventinternal1 1 No username given..."
could someone please help me with this?
$ip = 'IP_ADDRESS'; #IP of your cPanel/WHM server
$user = 'cpanel_username'; #cpanel username
$pass = 'password_hosting'; #password of your cPanel user
$xmlapi = new xmlapi($ip);
$xmlapi->password_auth($user,$pass);
$xmlapi->set_port(2083);
$xmlapi->set_output("xml");
$xmlapi->set_debug(1);
$dominio='domain.com';
print $xmlapi->api1_query($user, "Mysql", "adddb", 'db_name');
//create user
print $xmlapi->api1_query($user, "Mysql", "adduser", array(
'user' => 'db_user',
'pass'=>'some_p@assw0rd'));
//add user to database
$xmlapi->api1_query($user, "Mysql", "adduserdb", array(
'user'=>'cpanel_username_db_user',
'db' => 'cpanel_username_db_name',
'SELECT INSERT UPDATE CREATE DELETE ALTER DROP'));
i've got this error message
"..Mysqladdusereventinternal1 1 No username given..."
could someone please help me with this?