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 12.5 control panel.
- How to view your databases
- How to add a new database
- How to edit your database password
- How to delete an existing database
- How to view your database users
- How to add a new database user
- How to edit your database user password
- How to delete an existing database user
Please note: This KB article is for Reseller Hosting accounts purchased after December 2014.
How to view your databases
Login to your account
Firstly you'll need to login into your Plesk 12.5 control panel, which will be at a URL similar to https://your_server_number.xenserve.com:8443/
Once you have logged in, click on the 'Domains' option, in the left hand menu.
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.
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'.
How to add a new database
Choose 'Add New Database'
To create a new database, click on the button labelled 'Add New Database'
Enter database information
This will bring up a form. Fill in the form with the relevant information, including;
- A database name.
- A database username.
- A password.
When you're done, click 'OK' to save your changes and create a new database.
How to edit your database
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'.
How to delete an existing database
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.
How to view your database users
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.
How to add a new database user
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.
Enter database user information
This will bring up a form. Simply fill in the form with the following information.
- A database username
- A password
- Repeat password
When you're done, click 'OK' to save your changes.
How to delete an existing database user
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.