1. Home
  2. Docs
  3. Developer Guide
  4. API Manager
  5. Functions
  6. MySQL Users
  7. add

add

Functionusermysql
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);
Was this article helpful to you? Yes No