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.

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.

 

  • 16 Users Found This Useful
Was this answer helpful?

Related Articles

How to add a user to a database and add privileges?

1. Log into your cPanel account.2. In the "Databases" section, click on "MySQL Databases"...

How to edit database table via phpMyAdmin in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "phpMyAdmin" Icon. 3. In...

How to delete a database in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "MySQL Databases"...

How to create a database in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "MySQL Databases"...

How to optimize database via phpMyAdmin in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "phpMyAdmin" Icon. 3. In...