Previous Next  

Mysql - Drop User

To drop or delete a user in MySQL, you can use the `DROP USER` statement followed by the `username` and `host`. Here's the basic syntax:

DROP USER 'username'@'host';

Where `username` is The username you want to drop and `host` is The host from which the user is allowed to connect.

For example, to drop a user named `olduser` that can connect from any host, you would use the following SQL statement:

DROP USER 'olduser'@'%';

After dropping the user, you should also revoke any privileges that were granted to the user.

  Previous Next  

Aspirant's Home is an innovative educational and career development platform designed to empower individuals in achieving their academic and professional aspirations.
Terms of Use   About Us   Privacy Policy