Managing Databases

Operator: <database>

XML Schema: database_input.xsd, database_output.xsd

Plesk version: Plesk 8.1 for Windows | Plesk 8.1 for Unix

API RPC version: 1.4.2.0 and higher

Plesk user: Administrator, customer

Description

Databases are used to store information in a tables format. You can add users to a database (create their own accounts) to grant them access to this information. One of the database user accounts (hereinafter referred to as database administrator) is used for administering the database via the Plesk graphical user interface (DB WebAdmin tool) or by connecting directly to the database server.

Supported operations

• ADD-DB creates database entry of the specified type, defining the webspace that will use it
• DEL-DB removes database entry; If a database is used by an application installed on the server, it cannot be removed
• GET-DB retrieves database parameters by the ID, webspace name or webspace ID
• SET-DEFAULT-USER specifies a database administrator
• GET-DEFAULT-USER retrieves ID of administrator of a specified database
• ADD-DB-USER creates a database user account for a specified database
• DEL-DB-USER removes a database user account from a specified database
• GET-DB-USERS retrieves the list of users of a specified database
• SET-DB-USER changes credentials of a database user

Remarks

Before working with databases, be sure to call operation get_supported_types or the db_server operator in order to retrieve information on which database servers are configured on the specific Plesk server.

Please send us your feedback on this help page.