Previous page | Next page | Locate page |

### Setting Up Remote Database Hosting

After you have set up the required remote database server, you need to register this database server in Parallels Plesk Panel.

To register a database server with Parallels Plesk Panel:

1. Log in to Parallels Plesk Panel.
2. Go to Home > Database Servers (in the Server group), and click Add Database Server.
3. Specify the properties of the database server:
   - Specify database server engine in the Database server type menu.
   - Specify hostname or IP address of the database server.
   - Specify the port number the database server is listening on. This option is available only for MySQL. By default, MySQL servers listen on port 3306. You can leave the Port number box blank, if your MySQL database server is listening on the default port.

     Note: Do not enter the value for MySQL server port equal to 8306, because it is used by Parallels Plesk Panel for communication with its internal database.

   - Specify which database type is running on the database server.
   - To make this database server default for hosting customers' databases, select the Use this server as default for MySQL check box. If you have a MS SQL database server, select the check box Use this server as default for MS SQL labeled.
   - Specify the database server administrator's login name and password.
4. Click OK.

To set up database hosting preferences that will affect all databases created through Parallels Plesk Panel:

1. Go to Home > Database Servers (in the Server group) > Preferences.
2. To simplify maintenance of customers' databases, select the Add user's login name and underscore to beginning of database names check box. All names of newly created databases will look like client's login name_database name. This will allow you to locate databases related to a particular Parallels Plesk Panel user. Note that even if you do not select this check box, on creation of a new database, Parallels Plesk Panel will add client's login name to the database name input box, and you will be able to edit it or remove it.
3. You can also set up Parallels Plesk Panel to add client's login names to corresponding database user names, further simplifying the maintenance of customers' databases. To do so, select the Add user's login name and underscore to the beginning of database user names check box. All names of newly created database users will look like client's login name_database user name. This will allow you to locate database users related to a particular Parallels Plesk Panel user.
4. Specify whether creation of databases is allowed on your Parallels Plesk Panel server. Some applications do not support remote databases and can work only with databases hosted on the same server. We recommend leaving the default option Allow local hosting of databases for these Web applications selected, otherwise, you will not be able to use such applications.
5. Click OK.

If you want to back up databases hosted on a remote MS SQL Database Server you set up earlier, you need to configure the backup settings for that MS SQL Database Server.

To configure backup settings for remote MS SQL Database Server:

1. Go to Home > Database Servers (in the Server group) and click the required remote MS SQL Database Server name.
2. Specify the temporary directory for remote MS SQL Database Server in the Temporary network directory field.

   This directory can be located anywhere in your network and it is required for backing up and restoring MS SQL databases. This directory must be accessible over the network by both the Parallels Plesk Panel server and the MS SQL server: both Parallels Plesk Panel and the user that is running remote MS SQL Database Server must have read/write access to this directory.

3. Provide username and password required for accessing the temporary network directory.
4. Click OK.