This is the simplest way to delete (drop) a user from your MySQL database.
DROP USER IF EXISTS username
The DROP USER
command was added in MySQL 5.7. In earlier versions you need to modify the grant tables directly. For example, using INSERT
, UPDATE
, or DELETE
statements. Use the FLUSH PRIVILEGES
statement to make your changes take effect (otherwise a server restart is required).
mysql> delete from user where user='username'; mysql> FLUSH PRIVILEGES;
What are MySQL users?
Just like software applications require an username and password for each human user, databases implement authentication in a similar way. With databases, the user accounts most often represent the application. For example a database administrator might create an database user account called “wordpress” for use by the WordPress application. The WordPress application uses the one database user account on behalf of all human users.