How To Remove a User from MySQL Database in cPanel?

Remove a User from MySQL Database

MySQL is a fast, easy-to-use RDBMS being used for many small and big businesses. MySQL is developed, marketed and supported by MySQL AB, which is a Swedish company. It is reliable, scalable, and fast. It is an open source RDBMS based on SQL language. To remove a user from MySQL database, follow the below steps

Step 1: Login to cPanel

Step 2: Select the option ‘MySQL Databases’ under the section Databases

Step 3: Go to current database section, select the database username which is needed to be removed

Step 4: To remove the user, click the delete symbol near the username

Step 5: A confirmation message will be displayed and click the option “Revoke User privileges from Database”

Step 6: To check the removal of the user, click the option “Go back” and now the username will be removed successfully from the database

Step 1 Login into cPanel.

Step 2 Click the “MySQL Databases” icon under Database section.

Select MySQL databases under Databases

Step 3 Go to current Database section, you need to select which database username is need to be removed.

Select the username to be removed

Step 4 Click the Delete Symbol near the user name to remove a particular user from the database.

Click the Delete Symbol near in user name

Step 5 It shows the confirmation message and then click the option “Revoke User Privileges from Database”. Then click “Go Back” to check the removal of the user.

It shows the confirmation message and then click it

Step 6 Successfully deleted the user from the database and it is updated in the current Database.

Successfully deleted the user from database