Let's say bobrocker was fired and we don't want that user to have access anymore. We can drop users from the database, like:

drop user 'bobrocker'@'localhost';