Labels

Monday, 7 November 2016

MySQL - How to drop user in My SQL

Dropping user in MySQL

We can drop user in MySQL in the below methods

1. Drop a User 
USE mysql;
SELECT * FROM user WHERE user = 'KRISH';

USE mysql;
DROP USER KRISH;

2.  Drop the user1@domain1.com user account
USE mysql;
DROP USER user1@domain1.com;
3. Delete anonymous users
USE mysql;
SELECT * FROM user WHERE user = '';
DELETE FROM user WHERE user = '';

No comments:

Post a Comment