the syntax is
GRANT USAGE ON DB.* to 'ff@localhost' IDENTIFIED BY PASSWORD
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
> 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?
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> 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.