Assigning Default Database Users

The default database user is used by Plesk for accessing a database if no other user is specified. The default database user, like any other database user, can manage the database either in the database management tool (such as phpMyAdmin) or by connecting directly to the database server. You can set any database user account as default. If you create a database, the first user created in the database will be the default database user.

In this chapter:

Request Packet Structure

Response Packet Structure

Samples

 

Request Packet Structure

A request XML packet assigning a default database user includes the set-default-user operation node:

<packet>
<database>
   <set-default-user>
   ...
   </set-default-user>
</database>
</packet>

 

The set-default-user node is presented by type DatabaseSetDBInputType (database_input.xsd), and its graphical representation is as follows:

 

Remarks

You can set default users for multiple databases by using a single packet. Add as many set-default-user operations as the number of database default user's accounts you want to set.

<database>
   <set-default-user>
   ...
   </set-default-user>
...
   <set-default-user>
   ...
   </set-default-user>
</database>

Important: When creating request packets, put nodes and elements in the order they follow in the packet structure.

 

Response Packet Structure

The set-default-user node of the output XML packet is presented by type DatabaseSetDBOutputType (database_output.xsd) and structured as follows:

 

 

Samples

Assigning a Default Database User

This request packet sets the user with ID 35 as default for the database with ID 132.

<packet>
<database>
   <set-default-user>
      <db-id>132</db-id>
      <default-user-id>35</default-user-id>
   </set-default-user>
</database>
</packet>

Response:

<packet>
<database>
   <set-default-user>
      <result>
          <status>ok</status>
      </result>
   </set-default-user>
</database>
</packet>

The negative response from the server looks as one of the follows:


<packet>
<database>
   <set-default-user>

      <result>
          <status>error</status>
          <errcode>1015</errcode>
          <errtext>Database not found</errtext>
      </result>

   </set-default-user>
</database>
</packet>

 The user with ID=35 was not found in the database with ID=132.

<packet>
<database>
   <set-default-user>

      <result>
          <status>error</status>
          <errcode>1015</errcode>
          <errtext>Database not found</errtext>
      </result>

   </set-default-user>
</database>
</packet>