Re: deleting mysql users

2003-10-10 Thread Director General: NEFACOMP
ent a REMOVEUSER command. Thanks Emery - Original Message - From: "Alejandro Javier Pomeraniec" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 10, 2003 13:22 Subject: Re: deleting mysql users > Thanks !! > > Do you happen to know why my

Re: deleting mysql users

2003-10-10 Thread Victoria Reznichenko
Alejandro Javier Pomeraniec <[EMAIL PROTECTED]> wrote: > Thanks !! > > Do you happen to know why mysql decided not to erase those users?? > It's how REVOKE works. REVOKE doesn't remove user entry from the table 'user'. From version 4.1.1 you can use DROP USER command to delete user: ht

Re: deleting mysql users

2003-10-10 Thread Alejandro Javier Pomeraniec
Thanks !! Do you happen to know why mysql decided not to erase those users?? On Fri, 10 Oct 2003 17:07:12 +0300 Victoria Reznichenko <[EMAIL PROTECTED]> wrote: > Alejandro Javier Pomeraniec <[EMAIL PROTECTED]> wrote: > > > > Whenever i create a database user using GRANT command, mysql add

Re: deleting mysql users

2003-10-10 Thread Victoria Reznichenko
Alejandro Javier Pomeraniec <[EMAIL PROTECTED]> wrote: > > Whenever i create a database user using GRANT command, mysql add a register inside > the user table in mysql database. I've noticed that if i use REVOKE to revoke all > privileges from that user, mysql does not delete the register from u

RE: deleting mysql users

2003-10-10 Thread Fortuno, Adam
That's how I do it. Take the user out of both the user and db tables. -Original Message- From: Alejandro Javier Pomeraniec [mailto:[EMAIL PROTECTED] Sent: Friday, October 10, 2003 6:33 AM To: [EMAIL PROTECTED] Subject: deleting mysql users Hi !! Whenever i create a database user using G