If you're referring to a USER having access to a specific database, one way you can do remove the user from the mysql database structure (if you have root access), then to set up an identical user by
grant ALL [or specific operations] on yourdb.* to newuser identified by 'newpassword' [with grant option]
not sure that's what you're wanting to do.
Sam