delete old mysql users

2002-03-18 Thread Steve Wright
Hello, I have a system running MySQL with old user accounts I wish to remove. I am looking for a command to delete all user that do not have access to any databases. Does anyone know of such a command ?? With Thanks, Steve.

RE: delete old mysql users

2002-03-18 Thread Simon Green
] Subject: delete old mysql users Hello, I have a system running MySQL with old user accounts I wish to remove. I am looking for a command to delete all user that do not have access to any databases. Does anyone know of such a command ?? With Thanks, Steve

Re: delete old mysql users

2002-03-18 Thread Joel Rees
Steve Wright queried I am looking for a command to delete all user that do not have access to any databases. Does anyone know of such a command ?? Off-the-wall answer from a newbie: Since the user information is kept in a table, it should be fairly easy to build a short MySQL script to do