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 it.

The database name is mysql and the tables in it are user and db, I think.

Joel Rees
Alps Giken Kansai Systems Develoment
Suita, Osaka




---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to