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=gcdmg-mysql-2@m.gmane.org

RE: revoke all on *.* ??

--_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@yahoo.co.uk
> To: mysql@lists.mysql.com
> 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@hotmail.c=
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_--

Re: revoke all on *.* ??

peljasz@yahoo.co.uk (Pawel Eljasz) writes:

> there is a user with following grants:
> GRANT USAGE ON *.* TO 'ff'@'localhost' IDENTIFIED BY PASSWORD
> 'xxxxxxxxx'
> is it possible to:
> revoke all on *.* from $above_user OR revoke usage on *.* from $above_user
> ?

DROP USER ff@localhost;

Simon

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org