Managing Databases

With Plesk you can create multiple databases and multiple users within each database, and make use of DB WebAdmin - a web-based administration tool, allowing you to sort, edit, and create tables within a given database.

 

Creating a New Database

  1. At the Domain administration page, click the  Databases icon. The Databases Management page appears:

  2. Click  Add New Database. The page appears:

  3. Enter the desired name for the database, select the database type and click OK. The Database Users page appears:

  4. To add database users to the newly created database, click  Add New Database User. The Database user addition page appears:

  5. Enter the user name into Database user name text box, specify a password in the New Password text box, and then enter it again in the Confirm Password text box. Select OK to complete the creation of new user.

  6. Once you have completed the creation of the new database and its users click Up Level to return to the Databases Management page.

  7. To add further databases, follow the steps outlined above.

 

Editing a Database

  1. On the Databases Management page, click on the database name that you wish to edit. The Database Editing page appears:

  2. To add database users to the selected database, click  Add New Database User. The Database user addition page appears:

  3. Specify user name, enter new password in the New Password text box, and then re-enter it into the Confirm Password text box. Select OK to complete creation of the new user. Selecting Up Level will ignore all entries and return to the Database Editing page making no changes.

  4. To edit the password of an existing database user, select the user from the database user list.

  5. To delete existing database users select the users that you wish to delete using the corresponding checkboxes, and click Remove Selected.

  6. To access and/or edit database content use the  DB WebAdmin function.

  7. Once you are finished with editing the database and its users, click Up Level to return to the Database Management page.

  8. To delete databases from the system, select the databases that you wish to delete using the checkboxes and click Remove Selected.

  9. To edit further databases, follow the steps outlined above. To return to the Domain Administration page, click Up Level.

  • 43 Users Found This Useful
Was this answer helpful?

Related Articles

Domain Report and Statistics

To view the domain report, click the Report icon on the Domain administration page. The report...

Customizing DNS Settings

Through Plesk, you can customize DNS settings for each domain created. The Plesk administrator...

Editing Traffic Statistics Retention Settings

To adjust the traffic statistics retention period, follow these steps: Click the ...

Viewing Resource Usage Limits

You can check out the limits on resource usage and domain validity period. To do that:...

Managing Mail

You can use the following e-mail administration functions in Plesk: Create,...

Powered by WHMCompleteSolution