RE: I can't remove a user

2001-04-03 Thread Cal Evans
delete from user where user='tvinhas' and host='localhost'; delete from db where user='tvinhas' and host='localhost'; Cal http://www.calevans.com -Original Message- From: Thiago Vinhas de Moraes [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 2:51 PM To: [EMAIL PROTECTED] Subj

Re: I can't remove a user

2001-04-03 Thread Steve Werby
"Thiago Vinhas de Moraes" <[EMAIL PROTECTED]> wrote: > Can anyone help me with a probably simple issue? > > All I need to be happy forever is to the inverse of the following: > > insert into user (host, user, password) values ("localhost", "tvinhas", > password("phl1nao8")); > > and > > insert int

Re: I can't remove a user

2001-04-03 Thread Lindsay Adams
Have you tried using REVOKE instead? Are you sure YOU have DELETE privilege on the mysql database? You should be able to: DELETE FROM mysql.user where User='tvinhas'; And from the other databases that use the User field. On 4/3/01 12:51 PM, "Thiago Vinhas de Moraes" <[EMAIL PROTECTED]> wrote: