Pawel-
the syntax is
GRANT USAGE ON DB.* to 'ff@localhost' IDENTIFIED BY PASSWORD
'NeverShowYourPasswordInEmail'
http://dev.mysql.com/doc/refman/5.0/en/grant.html
HTH
Martin Gainty
______________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business of Sender.
This transmission is of a confidential nature and Sender does not endorse distribution to
any party other than intended recipient. Sender does not necessarily endorse content
contained within this transmission.
> Date: Tue, 10 Jun 2008 12:45:24 +0100
> From: peljasz@stripped
> To: mysql@stripped
> Subject: revoke all on *.* ??
>
> dear all
> mysql 5.0.51a, very basic config thus I don't think could be of any
> relevance here
> there is a user with following grants:
> GRANT USAGE ON *.* TO 'ff'@'localhost' IDENTIFIED BY PASSWORD
> '077042fb4932b5b5'
> is it possible to:
> revoke all on *.* from $above_user OR revoke usage on *.* from $above_user
> ?
> when I execute this I get no errors, but show grants still show there
> are privileges
> is it possible to make a user able to view and work only on one specific db?
> I think of it in respect of phpmyadmin, like user can only access a
> specific DB and no access to
> anything else whatsoever?
>
> cheers
> P.
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
_________________________________________________________________
Enjoy 5 GB of free, password-protected online storage.
http://www.windowslive.com/skydrive/overview.html?ocid=TXT_TAGLM_WL_Refresh_skydrive_062008
