Removing a user deletes that user - it removes all database permissions that the user has and does not allow that user access to any mySQL databases.
To remove a user:
Click on the SQL Database link in the Advanced Menu area.
Click on the
button next to the specific user in the Users area.