The REVOKE command should do most of the job for you, which is removing the privileges for a specific user. See the manual for more.
However, the user remains defined in the "user" table (while having no privileges), until one with access, deletes him/her manually. HTH, Lian > -----Original Message----- > From: Stephan Samuel [mailto:[EMAIL PROTECTED] > Sent: Monday, July 07, 2003 5:39 PM > To: [EMAIL PROTECTED] > Subject: Delete user/no access to mysql db > > > Hi. > > I'm using MySQL on my web host. I'm a dba of the db's that I create, but I > have no access to the mysql db. I can create users (GRANT USAGE > ON my_db ... > works), but I don't know how to get rid of them. > > I searched the manual, and the only reference to removing users > that I could > find was deleting records from mysql.user. Is there another way? > > Thanks, > Stephan Samuel > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
