Mysql
User Management
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.
get/Mysql/list_routines
Query parameters
database_userstring
Example:db_user
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.
Response
HTTP Request was successful.
Example response
{
"apiversion": 3,
"func": "list_routines",
"module": "Mysql",
"result": {
"data": [
"cptest_newdb.hello",
"cptest_newdb.my_routine"
],
"metadata": {
"transformed": 1
},
"status": 1
}
}