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 Plesk.

To register a database server with Plesk:

1. Log in to Plesk.
2. Go to Server > Database Servers 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 Plesk 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 Plesk:

1. Go to Server > Database Servers > Preferences.
2. To simplify maintenance of customers' databases, select the Add client'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 Plesk user. Note that even if you do not select this check box, on creation of a new database, Plesk 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 Plesk to add client's login names to corresponding database user names, further simplifying the maintenance of customers' databases. To do so, select the Add client'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 Plesk user.
4. Specify whether creation of databases is allowed on your Plesk 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 site 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 Server > Database Servers 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 Plesk server and the MS SQL server: both Plesk 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.