To delete a database in Plesk. Be aware that deleting a database will permanently remove all data, so ensure you have a backup if needed before proceeding.
Follow these simple steps:
Step 1: Log in to Plesk
- Open your Plesk control panel by navigating to
https://your-domain.com:8443(replaceyour-domain.comwith your actual domain or server IP address). - Enter your admin username and password to log in.
Step 2: Access the Database Management Section
- After logging in, go to the "Websites & Domains" tab from the Plesk dashboard.
- Find the domain for which you want to delete the database.
- Under the "Web Hosting" section, click on "Databases". This will open the Database Management page, where you can see all the databases associated with your domain.
Step 3: Select the Database to Delete
- On the Databases page, you will see a list of all the databases associated with the selected domain.
- Find the database you wish to delete and click on the "Remove" link (or trash can icon) next to the database.
Step 4: Confirm Deletion
- A confirmation message will appear asking if you are sure you want to delete the database.
- Click "OK" or "Yes" to confirm the deletion.
Step 5: Database Deletion Complete
- The database will be permanently deleted, and you will no longer see it listed under Databases for that domain.
Important Notes:
- Data Loss: Deleting a database is irreversible. Make sure you have a backup of the data if necessary. You can use Plesk’s backup feature or tools like phpMyAdmin to export your database before deleting it.
- Database User: Deleting the database will not automatically delete the associated database user. You may need to manually delete the user if no longer needed.
Step 6: (Optional) Remove Database User
If you want to delete the database user associated with the deleted database:
- Go back to the Databases page.
- Click on Database Users.
- Find the user associated with the database you deleted and click the Remove link.
By following these steps, you can easily delete a database in Plesk and remove any associated data. Always remember to back up any important data before performing such actions.
