Configuring and Maintaining Your Server 77
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.
