# Update MySQL user privileges

This function sets a MySQL® database user's privileges.



When you disable the  role,  remote MySQL is  already configured, the system  this function.

Endpoint: GET /Mysql/set_privileges_on_database
Version: 11.134.0.5
Security: BasicAuth

## Query parameters:

  - `database` (string, required)
    The database's name.



If database prefixing is enabled, you  prefix this value with the account prefix and an underscore (). For example, for the  database on the  cPanel account, pass in a value of .
    Example: "cpuser_dbname"

  - `user` (string, required)
    The database user's name.



If database prefixing is enabled, you  prefix this value with the account prefix and an underscore (). For example, for the  user on the  cPanel account, pass in a value of .
    Example: "cpuser_dbuser"

  - `privileges` (string)
    * 
* A comma-separated list of one or more of the following individual privileges:
  * 
  * 
  * 
  * 
  * 
  * 
  * 
  * 
  * 
  * 
  * 
  * 
  * 
  * 
  * 
  * 
  * 
  * 



* This list replaces, rather than adds to, the existing privilege list.
* In browser-based and command line calls, separate multiple values with  and replace spaces with .
    Example: "DELETE,UPDATE,CREATE,ALTER"

## Response 200 fields (application/json):

  - `apiversion` (integer)
    The version of the API.
    Example: 3

  - `func` (string)
    The name of the method called.
    Example: "set_privileges_on_database"

  - `module` (string)
    The name of the module called.
    Example: "Mysql"

  - `result` (object)

  - `result.data` (object,null)

  - `result.errors` (array,null)
    List of errors if the API failed.

  - `result.messages` (array,null)
    List of messages generated by the API.

  - `result.metadata` (object)

  - `result.status` (integer)
    - 1 - Success
- 0 - Failed: Check the errors field for more details.
    Enum: 0, 1

  - `result.warnings` (array,null)
    List of warnings generated by the API. Warnings describe non-critical failures or other problematic conditions noted while running a API.