From: Martin Gainty
Date: June 10 2008 12:16pm
Subject: RE: revoke all on *.* ??
List-Archive: http://lists.mysql.com/mysql/213264
Message-Id: <BLU142-W26D298C3336CEA394B1970AEB30@phx.gbl>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="_9b97e987-a6a5-41e9-89c5-c16a25b6a7fb_"

--_9b97e987-a6a5-41e9-89c5-c16a25b6a7fb_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Pawel-

the syntax is
GRANT USAGE ON DB.* to 'ff@localhost' IDENTIFIED BY PASSWORD=20

'NeverShowYourPasswordInEmail'

http://dev.mysql.com/doc/refman/5.0/en/grant.html

HTH
Martin Gainty=20
______________________________________________=20
Disclaimer and confidentiality note=20
Everything in this e-mail and any attachments relates to the official busin=
ess of Sender. This transmission is of a confidential nature and Sender doe=
s not endorse distribution to any party other than intended recipient. Send=
er does not necessarily endorse content contained within this transmission.=
=20


> Date: Tue, 10 Jun 2008 12:45:24 +0100
> From: peljasz@stripped
> To: mysql@stripped
> Subject: revoke all on *.* ??
>=20
> dear all
> mysql 5.0.51a, very basic config thus I don't think could be of any=20
> relevance here
> there is a user with following grants:
> GRANT USAGE ON *.* TO 'ff'@'localhost' IDENTIFIED BY PASSWORD=20
> '077042fb4932b5b5'
> is it possible to:
> revoke all on *.* from $above_user  OR revoke usage on *.* from $above_us=
er
> ?
> when I execute this I get no errors, but show grants still show there=20
> 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=20
> specific DB and no access to
> anything else whatsoever?
>=20
> cheers
> P.
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around=20
> http://mail.yahoo.com=20
>=20
>=20
> --=20
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=3Dmgainty@stripped=
om
>=20

_________________________________________________________________
Enjoy 5 GB of free, password-protected online storage.
http://www.windowslive.com/skydrive/overview.html?ocid=3DTXT_TAGLM_WL_Refre=
sh_skydrive_062008=

--_9b97e987-a6a5-41e9-89c5-c16a25b6a7fb_--