How to manage your databases

Applies to:
Reseller Hosting

Difficulty:
Easy

Time Needed:
5 minutes

Introduction

This is a quick step-by-step guide to viewing, editing, adding and removing databases & database users on a Reseller Hosting account, via the Plesk Onyx control panel.


Article Contents



How to view your databases in Plesk Onyx


Step 1

Login to your account

Firstly you'll need to login into your Plesk Onyx control panel, which will be at a URL similar to https://your_server_number.xenserve.com:8443/

Login to your account

Step 2

Choose 'Subscriptions'

Once you have logged in, click on the 'Subscriptions' option, in the left hand menu.

Choose 'Subscriptions'

Step 3

Choose Your Site

This will bring up a list of websites you have on your Reseller Hosting account.

Locate the domain name you wish to access, then simply click on it.

Choose Your Site

Step 4

Managing your databases

This will bring up a an overview of your selected domain. To view a list of database on this domain, simply click on the button labelled 'Databases'.

Managing your databases

How to add a new database in Plesk Onyx


Step 1

Choose 'Add New Database'

To create a new database, click on the button labelled 'Add New Database'

Choose 'Add New Database'

Step 2

Enter database information

This will bring up a form. Fill in the form with the relevant information, including;

  1. A database name.
  2. A database username.
  3. A password.

When you're done, click 'OK' to save your changes and create a new database.

Enter database information

How to edit your database in Plesk Onyx


Step 1

Edit your database

Upon creating a new database, you will be returned to the database overview page. If you wish to edit your database via phpMyAdmin, simply click on the text reading 'phpMyAdmin'.

Editing your database

How to delete an existing database in Plesk Onyx


Step 1

Remove a database

If you wish to delete an existing database, simply click on the text reading 'Remove Database'. This will remove the database permanently. It will also remove the database user associated with this database.

Remove a database

How to view your database users in Plesk Onyx


Step 1

Managing your database users

When viewing the 'Databases' page, just click on the link labelled 'User Management'.

When you create a new database via Plesk, a new user is automatically created for that database. The 'Users' page provides an overview of your database users, with each user listed in a table. Along with viewing information on each user, you can edit, add or remove database users via the table.

Managing database users

How to add a new database user in Plesk Onyx


Step 1

Add new database user

If you wish to add a new database user, simply click on the button labelled 'Add New Database User' when viewing the 'Users' page.

Add new database user

Step 2

Enter database user information

This will bring up a form. Simply fill in the form with the following information.

  1. A database username
  2. A password
  3. Repeat password

When you're done, click 'OK' to save your changes.

Enter database user information

How to delete an existing database user in Plesk Onyx


Step 1

Remove database user

If you wish to delete a existing database user simply click on the checkbox next to the user you wish to remove. Then click on the button labelled 'Remove'. This will remove the database user permanently.

Please note: Deleting a database user does not remove the associated database.

Remove database user

Was this helpful?

   
126 people found this article helpful
34SP.com Rated 9.2 out of 10 based on 172 reviews Trust Pilot