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
?command and combine a
?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.
?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.
If we use the
?command post this
?command, the user will not be connected and will not be able to connect to the database from now on.