Have you tried: GRANT USAGE on mysql.* TO ... (fill in with your user's information).
>From the docs (http://dev.mysql.com/doc/mysql/en/GRANT.html) USAGE = Synonym for ``no privileges'' Yours, Shawn Green Database Administrator Unimin Corporation - Spruce Pine Ginger Cheng <[EMAIL PROTECTED]> wrote on 07/23/2004 02:58:31 PM: > Hello, MySQL gurus, > I am wondering how I can grant a user the privileges to all the db except > for mysql DB. THere are many databases so I don't want to grant one by one. > But 'revoke all on mysql.* from user' does not work. Thank you for help > ginger > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >