How do I manage databases in the Plesk control panel?

The Plesk Control Panel has the ability to create multiple MySQL and PostgreSQL databases as well as multiple users within each database. Also, directly accessible via Plesk, are the links to phpMyAdmin and PhpPGAdmin, the PHP interface applications that abstract mysql or postgresql into a web-based administration tool, allowing you to sort, edit, and create tables within a given database.

Before creating your databases within the Plesk Control Panel, please ensure that you have already added a hosted domain name to your dedicated server.

Here is how you can create MySQL (or PostgreSQL) databases using Plesk:

  1. Login to your Plesk Control Panel. Use the login details sent to you in the "Welcome" email when the server was initially setup.
  2. Click on Domains from the navigation bar on the left.

  1. Select the domain name that you'd like to associate your database with.
  2. Click the Databases icon.

  1. Click the Add New Database icon.

  1. Enter a name in the Database name field.

  2. Select the Database Type using the respective drop-down menu.
  3. Select the Database Server using the respective drop-down menu.
  4. Click OK.
  5. Click the Add New Database User icon in order to setup database administrator's credentials.

  1. Enter a username and a password which will be used for accessing the contents of the database.
  2. Click OK.
  3. Now, you can use the DBWebAdmin tool to access the phpMyAdmin tool where you can create, edit and sort tables within your database.

Posted in
Last update:
2015-12-03 20:39
Average rating:0 (0 Votes)