List:General Discussion« Previous MessageNext Message »
From:Martin Gainty Date:June 10 2008 12:16pm
Subject:RE: revoke all on *.* ??
View as plain text  
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
Thread
revoke all on *.* ??Pawel Eljasz10 Jun
  • RE: revoke all on *.* ??Martin Gainty10 Jun
  • Re: revoke all on *.* ??Simon J Mudd10 Jun