How to remove a user from a MySQL database in cPanel

How to remove a user from a MySQL database in cPanel?

  1. You need to log in to the cPanel while using username and password provided for your web hosting account.
  2. Click on the MySQL Databases icon and move for the next step.
  3. You need to locate the database that for which you want to remove a user. You can find the database under table of databases.
  4. Then you need to locate a specific user that is assigned for the database and if you wish to remove it, then click on the delete icon.
  5. To confirm the process, you need to click on the Delete User from Database icon.
  6. That’s it! That specific user will be deleted from the database. 
  • 69 Users Found This Useful
Was this answer helpful?

Related Articles

Can I connect to MySQL from my computer

Yes, you can. Just need to add your IP address in the hosts allowed to connect to MySQL. Adding...

Can’t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

If you receive this error message when connecting to MySQL trough command line on your VPS...

Export and import of MySQL databases from cPanel

For management on databases in your hosting account you can use the web application phpMyAdmin....

Export and import MySQL databases via SSH

If you want to import your MySQL database through SSH on your VPS or dedicated server, use the...

How to see the MySQL variables

Log into your MySQL database and type: show variables; You will see the following: mysql>...