Chapter 85: Controller: /siteworx/mysql/perms Up Part III: SiteWorx API Spec Chapter 87: Controller: /siteworx/notice 

86 Controller: /siteworx/mysql/user

Required Permissions "MYSQL"
Required Options MySQL Users
Action: add
Added in version 4.7.0-339
Description 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
Added in version 4.7.0-339
Description Delete a mysql user.
Input Parameters
Name Type Notes Required?
name struct (string) Example Values
testuser
Yes
Action: edit
Added in version 4.7.0-339
Description Edit a mysql user.
Input Parameters
Name Type Notes Required?
name string Example Values
testuser
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
Added in version 4.7.0-339
Description List MySQL users.
Warning This action has been deprecated as of version 4.8.0-393. 2010-12-03 use listMysqlUsers
Sample output
array (
’status’ => 0,
’payload’ =>
array (
0 =>
array (
0 => ’testuser’,
1 => ’example_testuser’,
),
),
)
Action: listMysqlUsers
Added in version 4.8.0-393
Description List MySQL users.
Sample output
array (
’status’ => 0,
’payload’ =>
array (
0 =>
array (
’name’ => ’testuser’,
’fqun’ => ’example_testuser’,
’databases’ => ’example_mydb’,
),
),
)
Action: queryEdit
Added in version 5.1.0-838
Description Displays the information available to the action "edit".
Input Parameters
Name Type Notes Required?
name string Example Values
testuser
Yes
 Chapter 85: Controller: /siteworx/mysql/perms Up Part III: SiteWorx API Spec Chapter 87: Controller: /siteworx/notice 

(C) 2017 by InterWorx LLC