Knowledge Base Hub

Browse through our helpful how-to guides to get the fastest solutions to your technical issues.

Home  >  Web Hosting FAQ  >  How to delete a MySQL user ?
Top Scroll

How to delete a MySQL user ?

 2 min

If you wish to delete a MySQL user, login to your server via SSH & access MySQL prompt.

MySQL prompt

Select the database mysql & follow the steps below. Here, the database is mysql. Replace the database name as desired.

mysql> use mysql;
mysql> DELETE FROM user where user=’username’;
mysql> FLUSH PRIVILEGES;

Replace ‘username’ with the username of the user you wish to delete. Also, select the correct table which has the user records stored. You have to run this as the root user or an account that has appropriate privileges on the grant tables.

For our Knowledge Base visitors only
Get 10% OFF on Hosting
Special Offer!
30
MINS
59
SECS
Claim the discount before it’s too late. Use the coupon code:
STORYSAVER
Note: Copy the coupon code and apply it on checkout.