Controller: MysqlPerms

Action	Description
add	Add mysql permissions.
edit	Edit mysql permissions.
listAvailablePerms	List available MySQL permissions.
queryDatabaseUserPerms	Given a database, find all the db users and their permissions on that db.

Action: add

Add mysql permissions.

Name	Type	Notes	Required?
name	string	Example Values mydb	Yes
user	string	Example Values pko	Yes
perms	struct (string)	Example Values SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EXECUTE Example Default Value ["SELECT","INSERT","UPDATE","DELETE","CREATE","DROP","REFERENCES","INDEX","ALTER","CREATE TEMPORARY TABLES","LOCK TABLES","CREATE VIEW","SHOW VIEW","CREATE ROUTINE","ALTER ROUTINE","EXECUTE"]	No*
host	string	Example Default Value %	No*
* indicates that it's actually required, but probably already has a valid default value

Edit mysql permissions.

Name	Type	Notes	Required?
perms	struct (string)	Example Values SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EXECUTE Example Default Value ["CREATE","DROP","REFERENCES","ALTER","DELETE","INDEX","INSERT","SELECT","UPDATE","CREATE VIEW","SHOW VIEW","ALTER ROUTINE","CREATE ROUTINE","EXECUTE","CREATE TEMPORARY TABLES","LOCK TABLES"]	No*
* indicates that it's actually required, but probably already has a valid default value

List available MySQL permissions.

array (
  'status' => 0,
  'payload' => 
  array (
    0 => 'SELECT',
    1 => 'INSERT',
    2 => 'UPDATE',
  ),
)

Given a database, find all the db users and their permissions on that db.

Name	Type	Notes	Required?
name	string	Example Values mydb	Yes