RE: I can't remove a user

2001-04-03 Thread Cal Evans
il 03, 2001 2:51 PM To: [EMAIL PROTECTED] Subject: I can't remove a user Hi! 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", passwor

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:

I can't remove a user

2001-04-03 Thread Thiago Vinhas de Moraes
Hi! 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 into db (host, db, user, Select_priv, Insert_priv, Update_priv,