Deploying Databases
If your web server incorporates data processing applications or is designed to generate web pages dynamically, you will likely need a database for storing and retrieving data. You can either create a new database for your site or import the data from your previously backed up MySQL or PostgreSQL database.
To create a new database on your hosting account:
- On your Home page, click the domain name you need.
- Click
Databases. - Click
Add New Database. - 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).
- Select the database type that you are going to use: MySQL or PostgreSQL. Click OK.
- To set up database administrator's credentials, click
Add New Database User. - Type a user name and a password that will be used for accessing the contents of the database.
- Click OK.
To import an existing database:
- On your Home page, click the domain name you need.
- Click
Databases. - Click
Add New Database. - 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).
- Select the database type that you are going to use: MySQL or PostgreSQL. Click OK.
- To set up database administrator's credentials, click
Add New Database User. - Type a user name and a password that will be used for accessing the contents of the database. Click OK.
- Click the
DB WebAdmin icon in the Tools group. An interface to phpMyAdmin (or phpPgAdmin) database management tool will open in a separate browser window. - Click on the Query window icon in the left frame.
- Click the Import files tab.
- Select the text file that contains the data and click Go.
- Click the Insert data from a text file link.
To manage your databases and their contents, use your favorite MySQL or PostgreSQL client or the web based database management tool accessible from Plesk control panel (Home > domain name > Databases > Database name > DB WebAdmin).
To remove a database with its contents:
- On your Home page, click the domain name you need.
- Click the
Databases icon in the Services group. - Select a check box corresponding to the database that you wish to remove.
If the required check box appears grayed out, this means that this database is used by a site application and you can remove it only by uninstalling the respective application.
- Click
Remove Selected. - Confirm removal and click OK.
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:
- On your Home page, click the domain name you need.
- Click the
Databases icon in the Services group. - Click on a database name. A list of database users will open.
- Click
Add New Database User. - Type a user name and a password that will be used for accessing the contents of the database. Click OK.
To remove a database user account:
- On your Home page, click the domain name you need.
- Click the
Databases icon in the Services group. - Click on a database name. A list of database users will open.
- Select a check box corresponding to the user account that you wish to remove.
- Click
Remove Selected. Next, confirm removing and click OK.
To change password for a database user:
- On your Home page, click the domain name you need.
- Click the
Databases icon in the Services group. - Click on a database name. A list of database users will open.
- Click on the database user's name.
- Type a new password and click OK.