How to Remove a Database User in Plesk
Log in to your Plesk account. Click on Databases from the Sidebar Menu. Click on User Management from the right sidebar. Under Database Users, checkmark the appropriate database user you want to remove and click on Remove. A confirmation box will appear. Confirm with Yes to remove the user.
How to Download a Dump of a Database in Plesk
You can generate a backup of your database and download it to your computer using Plesk. Log in to your Plesk account. Click on Databases from the Sidebar Menu. Choose the database you want to download from the list of databases. Proceed with Export Dump, and a popup box will appear. Choose the directory where your database dump will be saved. Checkmark Automatically download dump after creation, and confirm with OK. Once a database dump is generated, your browser will prompt you to download it.
How to Add a User to a Database and Grant Privileges
Log in to your cPanel account. In the Databases section, click on MySQL Databases. Scroll down to the end of the page and under Add User to Database. Select a user from the drop-down list, and choose a Database from the list. Click on Add. On Manage User Privileges. Mark the box ALL PRIVILEGES and click on Make Changes.
How to Create a Database Username in cPanel
Log in to your cPanel account. In the Databases section, click on MySQL Databases. Under MySQL Users, in the Username field, enter the new username you want to create. Enter your new password or use a password generator. Click on Create a User. Tip: Write down the database username and password on a notepad so you can easily recall them while installing a script manually.
How to Create a New Database User in Plesk
Log in to your Plesk account. Click on Databases from the Sidebar Menu. Click on User Management from the right sidebar. Under Database Users, click on Add Database User. Under Adding Database User, fill in the following details: Database user name: Enter a database username such as blog. Password: Enter the password or click Generate to generate one. Then click on Show and copy the password in a safe place. Database: Choose the appropriate database from the drop-down menu. Access Control: Choose the appropriate option as per your needs. Finally, confirm with OK. Your new database user will be created.