Return MySQL user routines

This function returns a database user's MySQL® routines.

Important:

When you disable the MySQL/MariaDB role and remote MySQL is not configured, the system disables this function.

Authorizations:
query Parameters
database_user
string

The database user for whom to return MySQL routines. If you don't specify a database user, this function returns the MySQL routines for all database users.

Example: database_user=db_user

Responses

Response Schema: application/json
apiversion
integer

The version of the API.

func
string

The name of the method called.

module
string

The name of the module called.

object

Request samples

uapi --output=jsonpretty \
  --user=username \
  Mysql \
  list_routines

Response samples

Content type
application/json
{
  • "apiversion": 3,
  • "func": "list_routines",
  • "module": "Mysql",
  • "result": {
    • "data": [
      • "cptest_newdb.hello",
      • "cptest_newdb.my_routine"
      ],
    • "errors": null,
    • "messages": null,
    • "metadata": {
      • "transformed": 1
      },
    • "status": 1,
    • "warnings": null
    }
}