To create a new database on your hosting account:

1. On your Home page, click the domain name you need.
2. Click Databases.
3. Click Add New Database.
4. Enter a name for the database.

   We recommend that you choose a name that starts with a Latin alphabet symbol and comprises only alphanumeric and underscore symbols (up to 64 symbols).

5. Select the database type that you are going to use: MySQL or Microsoft SQL Server. Click OK.
6. To set up database administrator's credentials, click Add New Database User.
7. Type a user name and a password that will be used for accessing the contents of the database.
8. Click OK.

To import an existing database:

1. On your Home page, click the domain name you need.
2. Click Databases.
3. Click Add New Database.
4. Enter a name for the database. We recommend that you choose a name that starts with a Latin alphabet symbol and comprises only alphanumeric and underscore symbols (up to 64 symbols).
5. Select the database type that you are going to use: MySQL or Microsoft SQL Server. Click OK.
6. To set up database administrator's credentials, click Add New Database User.
7. Type a user name and a password that will be used for accessing the contents of the database. Click OK.
8. Click WebAdmin in the Tools group. An interface to phpMyAdmin (or ASPEnterpriseManager) database management tool will open in a separate browser window.

If you have a MySQL database:

1. Click Query window in the left frame, click the Import files tab,
2. Select the text file that contains the data and click Go.
3. Click the Insert data from a text file link.

If you have a MS SQL database:

1. Click the name of your database in the left frame
2. Click Query (the magnifying glass button)
3. Copy the text of your script into the text area and click Run Query.

To manage your databases and their contents, use your favorite MySQL or Microsoft SQL Server client or the web based database management tool accessible from Plesk control panel (Home > domain name > Databases > Database name > WebAdmin).

If you collaborate with other people on managing a web site and wish to give them access to the database, you should create separate user accounts for them.

To create a database user account:

1. On your Home page, click the domain name you need.
2. Click Databases in the Services group.
3. Click the required database name. A list of database users will open.
4. Click Add New Database User.
5. Type a user name and a password that will be used for accessing the contents of the database. Click OK.

To change password for a database user:

1. On your Home page, click the domain name you need.
2. Click Databases in the Services group.
3. Click the required database name. A list of database users will open.
4. Click the database user's name.
5. Type a new password and click OK.

To let your web applications use external databases for storing the data, you need to create connections to these external databases by installing appropriate ODBC drivers.

To install a new ODBC driver, creating a connection to an external database:

1. On your Home page, click the domain name you need.
2. Click ODBC Data Sources in the Services group.
3. Click Add New ODBC DSN.
4. Specify the ODBC connection name and description in the corresponding fields.
5. Select the required driver in the Driver field.
6. Click OK.
7. Choose the appropriate options on the driver configuration screen. Typically, you should specify the path to the database, user credentials and other connection options, depending on the selected driver.
8. Click Test to check whether the connection will function properly with provided settings. Click Finish to complete the creation.

To change settings of an existing ODBC connection:

1. On your Home page, click the domain name you need.
2. Click ODBC Data Sources in the Services group.
3. Click the required connection name in the list.
4. Change the settings as needed.
5. Click Test to check whether the connection will function properly with new settings. Click Finish to save changes.

To remove a database with its contents:

1. On your Home page, click the domain name you need.
2. Click Databases in the Services group.
3. Select a check box corresponding to the database that you wish to remove.

   If the required check box appears grayed out, this means that this database is used by a site application and you can remove it only by uninstalling the respective application.

4. Click Remove Selected.
5. Confirm removal and click OK

To remove a database user account:

1. On your Home page, click the domain name you need.
2. Click Databases in the Services group.
3. Click the required database name. A list of database users will open.
4. Select a check box corresponding to the user account that you wish to remove.
5. Click Remove Selected. Next, confirm removing and click OK

To remove a redundant ODBC connection:

1. On your Home page, click the domain name you need.
2. Click ODBC Data Sources in the Services group.
3. Select the checkbox corresponding to a connection you want to remove.
4. Click Remove Selected, confirm the removal and click OK.