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]>
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 archiv
