dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Intermediate
Feb 21, 2019

WEBINAR:

On-Demand

Building the Right Environment to Support AI, Machine Learning and Deep Learning


Employing DROP USER in MySQL

As with any database, MySQL provides powerful user management feature. Learn how to remove a user from the database.

DROP USER SRIDHAR

However, the catch here is that the user will be dropped immediately, but the current active sessions will be allowed and closed only after the user exits.

To overcome this, we can use our SHOW PROCESSLIST command and combine a KILL action to ensure that the user session is first terminated — and then removed — so that the user does not have any further access to the database.

The SHOW PROCESSLIST will have an output and a column Id. Use the value in the Id column for the KILL — command and the session will be terminated.

For example:

KILL 14435

If we use the DROP USER command post this KILL command, the user will not be connected and will not be able to connect to the database from now on.

M S Sridhar
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Thanks for your registration, follow us on our social networks to keep up-to-date