Controller: MysqlUser

API Controller /siteworx/mysql/user
Required Permissions ["MYSQL"]
Required Options MySQL Users
Action Description
add Add a mysql user.
delete Delete a mysql user.
edit Edit a mysql user.
list List MySQL users. DEPRECATED in version 4.8.0-393
listMysqlUsers List MySQL users.

Action: add

Add a mysql user.

Input Parameters

Name Type Notes Required?
name string Yes
password string Yes
confirm_password string
Help Entry
Confirm the password field by providing it again. Must match the password provided.
 Yes

Action: delete

Delete a mysql user.

Input Parameters

Name Type Notes Required?
name struct (string)
Example Values
pko
 Yes

Action: edit

Edit a mysql user.

Input Parameters

Name Type Notes Required?
name string
Example Values
pko
 Yes
password string Yes
confirm_password string
Help Entry
Confirm the password field by providing it again. Must match the password provided.
 Yes

Action: list

This action has been deprecated as of version 4.8.0-393.

MESSAGE: 2010-12-03 use listMysqlUsers

List MySQL users.

Example Output

array (
  'status' => 0,
  'payload' => 
  array (
    0 => 
    array (
      0 => 'pko',
      1 => 'example_pko',
    ),
  ),
)

Action: listMysqlUsers (Added in version 4.8.0-393)

List MySQL users.

Example Output

array (
  'status' => 0,
  'payload' => 
  array (
    0 => 
    array (
      'name' => 'pko',
      'fqun' => 'example_pko',
      'databases' => 'example_mydb',
    ),
  ),
)