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.

SecurityBasicAuth

Request

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

200

HTTP Request was successful.

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

get/Mysql/list_routines

Request samples

CLI
URL
LiveAPI Perl
LiveAPI PHP

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

Response samples

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
}
}