How do I delete a user from my MySQL database?

Databases: Delete MySQL User

Overview

There are two types of deleting users. One way is to delete a user from a database. The other type is to delete a user permanently.

Delete A User From The Database

Steps
  1. When the page loads, you will see a table containing the following information, split into five columns:
    • Database - This entry will be the database name you created in Step 1 above.
    • Size - This entry will be the size of the database you created in Step 1 above.
    • Users - This entry will be the users in the database.
    • Actions - You have once choice:
      • Delete Database - Click on this link to delete a database.
  2. First find the database you want to delete the user from in the "Database" column. Then find the user you want to delete from the "Username" column.
  3. Next, click on the x in a circle icon.
  4. You will see the following confirmation statement:
    • "Are you sure you wish to remove USERNAME User from the database DATABASE?"
  5. Click on the Yes button.
  6. Then click on the Go Back link.

The user you deleted should no longer be associated with the database you chose in Step 2 above.

Delete A User Permanently

Steps
  1. There will be a two-column table containing the "Users" and "Delete" column. Find the user you want to delete from the system and click on the x in a circle icon.
  2. You will see the following statement:
    • "Are you sure you wish to permanently remove the USERNAME User?"
  3. Click on the Yes button.
  4. You will see the following statement:
    • "Deleted the USERNAME."
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How do I repair my MySQL database?

Databases: Repair DB (MySQL)OverviewYou can repair your MySQL database by using the "Repair DB"...

How do I create a user in MySQL?

Databases: Create MySQL UserOverviewThere are two primary steps when creating a MySQL user. The...

How do I delete a MySQL database?

Databases: Delete MySQL DatabaseOverviewYou can easily delete a MySQL database from your web...

How do I setup remote access to my MySQL databases?

Databases: Remote (MySQL)OverviewRemote MySQL allows external web servers to access your MySQL...

How do I create a MySQL database?

Databases: Create MySQL Database CLICK HERE TO VIEW THE VIDEO TUTORIAL Overview MySQL...