REMOVING a user

[sfullman]

I have root access and understand the grant tables in mysql. And I understand REVOKE command so that I can lock out a user from the system.

However, to REMOVE a user (i.e. remove the records from the db and user table), I have to go in and delete them manually, then "Flush privileges"

It's not like that's too hard, but isn't there a native command that works the same way?

Thanks,
Sam Fullman

[barand]

You could write a php script to

"DELETE FROM columns_priv WHERE user = $user"
"DELETE FROM tables_priv WHERE user = $user"
"DELETE FROM user WHERE user = $user"

hth