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. Click the Server shortcut in the navigation pane.
3. Click the Database Servers icon in the Services group.
4. Click the Add Database Server icon in the Tools group.
5. 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.
6. 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 Force Database Prefix 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. 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.
4. Click OK.