Creating or Importing a Database

To create a new database on your hosting account:

1. Go to Domains > domain name > Databases and click Add New Database.
2. 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).

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

To import an existing database:

1. Go to Domains > domain name > Databases and click Add New Database.
2. 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).
3. Select the database type that you are going to use: MySQL, PostgreSQL, or Microsoft SQL Server. Click OK.
4. To set up database administrator's credentials, 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.
6. Click the DB WebAdmin icon in the Tools group. An interface to phpMyAdmin, phpPgAdmin, 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, PostgreSQL, or Microsoft SQL Server client or the Web based database management tool accessible from Parallels Plesk Panel (Domains > domain name > Databases > database name> DB WebAdmin).

Creating Database User Accounts

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. Go to Domains > domain name > Databases > database name, and click Add New Database User.
2. Type a user name and a password that will be used for accessing the contents of the database. Click OK.

Changing Database User Passwords

To change password for a database user:

1. Go to Domains > domain name > Databases > database name > database user name.
2. Type a new password and click OK.

Removing Database User Accounts

To remove a database user account:

1. Go to Domains > domain name > Databases > database name.
2. Select a check box corresponding to the user account that you want to remove.
3. Click Remove. Next, confirm removing and click OK.

Removing Databases

To remove a database with its contents:

1. Go to Domains > domain name > Databases.
2. Select a check box corresponding to the database that you want to remove.

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

3. Click Remove.
4. Confirm removal and click OK.

Accessing Data From External Databases

If you want to access data from an external database management system, you should create ODBC connections through Parallels Plesk Panel.

Creating Connections to External Databases

To let your Web applications use external databases for storing the data, you need to create connections to these external databases.

To create an ODBC connection to an external database:

1. Go to Domains > domain name >ODBC Data Sources.
2. Click Add New ODBC DSN.
3. Specify the ODBC connection name and description in the corresponding fields.
4. Select the required driver in the Driver field.
5. Click OK.
6. 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.
7. Click Test to check whether the connection will function properly with provided settings. Click Finish to complete the creation.

Changing Settings Of Existing ODBC Connections

To change settings of an existing ODBC connection:

1. Go to Domains > domain name >ODBC Data Sources.
2. Click the required connection name in the list.
3. Change the settings as needed.
4. Click Test to check whether the connection will function properly with new settings. Click Finish to save changes.

Removing Connections to External Databases

To remove a redundant ODBC connection:

1. Go to Domains > domain name >ODBC Data Sources.
2. Select the check box corresponding to a connection you want to remove.
3. Click Remove, confirm the removal and click OK.

Configuring Data Source Names for Adobe ColdFusion 

If you are using Adobe ColdFusion, you can configure data source names (DSNs) for ColdFusion through Parallels Plesk Panel. Data source names allow your ColdFusion Web applications to use local and remote databases for processing and storing application data.

Creating a New Data Source Name

To create a new Data Source Name for Adobe ColdFusion on a domain:

1. Go to Domains > domain name > ColdFusion DSN and click Add New ColdFusion DSN.
2. Specify the data source name and select the required driver for this data source in the Driver menu. Click Next >>.
3. 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. Refer to Adobe ColdFusion documentation for more information on the driver configuration options.
4. Click OK to finish.

Changing Settings of a Data Source Name

To change the settings of a data source name for Adobe ColdFusion on a domain:

1. Go to Domains > domain name > ColdFusion DSN and click the required data source name in the list.
2. Specify the data source name and select the required driver for this data source in the Driver menu. Click Next >>.
3. 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. Refer to Adobe ColdFusion documentation for more information on the driver configuration options.
4. Click OK.

Removing a Data Source Name

To remove a redundant ColdFusion DSN connection:

1. Go to Domains > domain name > ColdFusion DSN.
2. Select the check box corresponding to a DSN connection you want to remove.
3. Click Remove, confirm the removal and click OK.