add

Function: usermysql
To make use of the ‘add‘ Action, the following parameters must be sent:

• • key: Key authorized by Api administrator
  • action: add
  • user: Account username
  • userdb: Database User
  • pass: Password for the database user
  • dbase: Data Base Name (Max 8 Characters)
  • host: Name Host (%, Localhost, IP)

– Possible answers:

• • status -> OK
  • status -> Error, msj -> Duplicate data base name.
  • status -> Error, msj -> User already exists

Example of code in php

$data = array(“key” => “MYKEY”,”action”=>’add’, ”userdb”=>’MYUSERBD’, ”user”=>’USER’,"pass"=>'MYPASSW',"dbase"=>'MYDB',"host"=>'localhost');
$url = “https://IPSERVERAPI:2304/v1/usermysql”;
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_CUSTOMREQUEST, “POST”);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt ($ch, CURLOPT_POSTFIELDS, http_build_query($data));
curl_setopt ($ch, CURLOPT_POST, 1);
$response = curl_exec($ch);
curl_close($ch);