Pawel- the syntax is GRANT USAGE ON DB.* to '[EMAIL PROTECTED]' 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: [EMAIL PROTECTED] > To: mysql@lists.mysql.com > 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/[EMAIL PROTECTED] > _________________________________________________________________ Enjoy 5 GB of free, password-protected online storage. http://www.windowslive.com/skydrive/overview.html?ocid=TXT_TAGLM_WL_Refresh_skydrive_062008