Verify User Privileges

I would like to know how I can verify what privileges have been
granted to a specific user on MySQL. I don't remember if my user
'carlos' has specific privileges on 'mydb' database. I am sure I could
simply re-run the following command:

GRANT ALL PRIVILEGES ON mydb.* TO 'carlos'@'localhost'
-> WITH GRANT OPTION;

I really would like to avoid redundant commands if I could verify that
my user 'carlos' already has the neccessary privileges on the specific
database(s) in question.

Thanks for any info / help!

-Carlos

--
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: Verify User Privileges

On Thu, May 27, 2010 at 12:26 PM, win.a wrote:
> Maybe phpmyadmin is a choice

No I am only allowed to have MySQL installed. No GUI for DBA. I am
sure there is a way to verify the privileges via CLI, I just can't
locate it on the site / documentation.

--
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: Verify User Privileges

U0hPVyBHUkFOVFMgRk9SICdjYXJsb3MnQCdsb2NhbGhvc3QnOw0KDQpSb2xh bmRvIEEuIEVkd2Fy
ZHMNCk15U1FMIERCQSAoQ01EQkEpDQoNCjE1NSBBdmVudWUgb2YgdGhlIEFt ZXJpY2FzLCBGaWZ0
aCBGbG9vcg0KTmV3IFlvcmssIE5ZIDEwMDEzDQoyMTItNjI1LTUzMDcgKFdv cmspDQoyMDEtNjYw
LTMyMjEgKENlbGwpDQpBSU0gJiBTa3lwZSA6IFJvbGFuZG9Mb2dpY1dvcngN CnJlZHdhcmRzQGxv
Z2ljd29ya3MubmV0DQpodHRwOi8vd3d3LmxpbmtlZGluLmNvbS9pbi9yb2xh bmRvZWR3YXJkcw0K
DQoNCi0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tDQpGcm9tOiBDYXJsb3Mg TWVubmVucyBbbWFp
bHRvOmNhcmxvc3dpbGxAZ21haWwuY29tXSANClNlbnQ6IFRodXJzZGF5LCBN YXkgMjcsIDIwMTAg
MTI6MDcgUE0NClRvOiBNeVNRTA0KU3ViamVjdDogVmVyaWZ5IFVzZXIgUHJp dmlsZWdlcw0KDQpJ
IHdvdWxkIGxpa2UgdG8ga25vdyBob3cgSSBjYW4gdmVyaWZ5IHdoYXQgcHJp dmlsZWdlcyBoYXZl
IGJlZW4NCmdyYW50ZWQgdG8gYSBzcGVjaWZpYyB1c2VyIG9uIE15U1FMLiBJ IGRvbid0IHJlbWVt
YmVyIGlmIG15IHVzZXINCidjYXJsb3MnIGhhcyBzcGVjaWZpYyBwcml2aWxl Z2VzIG9uICdteWRi
JyBkYXRhYmFzZS4gSSBhbSBzdXJlIEkgY291bGQNCnNpbXBseSByZS1ydW4g dGhlIGZvbGxvd2lu
ZyBjb21tYW5kOg0KDQpHUkFOVCBBTEwgUFJJVklMRUdFUyBPTiBteWRiLiog VE8gJ2NhcmxvcydA
J2xvY2FsaG9zdCcNCiAgICAtPiAgICAgV0lUSCBHUkFOVCBPUFRJT047DQoN CkkgcmVhbGx5IHdv
dWxkIGxpa2UgdG8gYXZvaWQgcmVkdW5kYW50IGNvbW1hbmRzIGlmIEkgY291 bGQgdmVyaWZ5IHRo
YXQNCm15IHVzZXIgJ2NhcmxvcycgYWxyZWFkeSBoYXMgdGhlIG5lY2Nlc3Nh cnkgcHJpdmlsZWdl
cyBvbiB0aGUgc3BlY2lmaWMNCmRhdGFiYXNlKHMpIGluIHF1ZXN0aW9uLg0K DQpUaGFua3MgZm9y
IGFueSBpbmZvIC8gaGVscCENCg0KLUNhcmxvcw0KDQotLSANCk15U1FMIEdl bmVyYWwgTWFpbGlu
ZyBMaXN0DQpGb3IgbGlzdCBhcmNoaXZlczogaHR0cDovL2xpc3RzLm15c3Fs LmNvbS9teXNxbA0K
VG8gdW5zdWJzY3JpYmU6ICAgIGh0dHA6Ly9saXN0cy5teXNxbC5jb20vbXlz cWw/dW5zdWI9cmVk
d2FyZHNAbG9naWN3b3Jrcy5uZXQNCg0K

Re: Verify User Privileges

--001485f6270c838ddb0487960f5b
Content-Type: text/plain; charset=UTF-8

On Thu, May 27, 2010 at 7:30 PM, Carlos Mennens wrote:

> On Thu, May 27, 2010 at 12:26 PM, win.a wrote:
> > Maybe phpmyadmin is a choice
>
> No I am only allowed to have MySQL installed. No GUI for DBA. I am
> sure there is a way to verify the privileges via CLI, I just can't
> locate it on the site / documentation.
>
>

#1
select host,user from mysql.user;

#2
show grants for USER@HOST;

--
Maurice

--001485f6270c838ddb0487960f5b--

RE: Verify User Privileges

SWYgeW91IGRvIG5vdCBoYXZlIGNlcnRhaW4gcmlnaHRzLCB0aGVuIGp1c3Qg ZG8NCg0KU0hPVyBH
UkFOVFM7DQoNClJvbGFuZG8gQS4gRWR3YXJkcw0KTXlTUUwgREJBIChDTURC QSkNCg0KMTU1IEF2
ZW51ZSBvZiB0aGUgQW1lcmljYXMsIEZpZnRoIEZsb29yDQpOZXcgWW9yaywg TlkgMTAwMTMNCjIx
Mi02MjUtNTMwNyAoV29yaykNCjIwMS02NjAtMzIyMSAoQ2VsbCkNCkFJTSAm IFNreXBlIDogUm9s
YW5kb0xvZ2ljV29yeA0KcmVkd2FyZHNAbG9naWN3b3Jrcy5uZXQNCmh0dHA6 Ly93d3cubGlua2Vk
aW4uY29tL2luL3JvbGFuZG9lZHdhcmRzDQoNCg0KLS0tLS1PcmlnaW5hbCBN ZXNzYWdlLS0tLS0N
CkZyb206IFJvbGFuZG8gRWR3YXJkcyBbbWFpbHRvOnJlZHdhcmRzQGxvZ2lj d29ya3MubmV0XSAN
ClNlbnQ6IFRodXJzZGF5LCBNYXkgMjcsIDIwMTAgMTI6MzkgUE0NClRvOiBD YXJsb3MgTWVubmVu
czsgTXlTUUwNClN1YmplY3Q6IFJFOiBWZXJpZnkgVXNlciBQcml2aWxlZ2Vz DQoNClNIT1cgR1JB
TlRTIEZPUiAnY2FybG9zJ0AnbG9jYWxob3N0JzsNCg0KUm9sYW5kbyBBLiBF ZHdhcmRzDQpNeVNR
TCBEQkEgKENNREJBKQ0KDQoxNTUgQXZlbnVlIG9mIHRoZSBBbWVyaWNhcywg RmlmdGggRmxvb3IN
Ck5ldyBZb3JrLCBOWSAxMDAxMw0KMjEyLTYyNS01MzA3IChXb3JrKQ0KMjAx LTY2MC0zMjIxIChD
ZWxsKQ0KQUlNICYgU2t5cGUgOiBSb2xhbmRvTG9naWNXb3J4DQpyZWR3YXJk c0Bsb2dpY3dvcmtz
Lm5ldA0KaHR0cDovL3d3dy5saW5rZWRpbi5jb20vaW4vcm9sYW5kb2Vkd2Fy ZHMNCg0KDQotLS0t
LU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KRnJvbTogQ2FybG9zIE1lbm5lbnMg W21haWx0bzpjYXJs
b3N3aWxsQGdtYWlsLmNvbV0gDQpTZW50OiBUaHVyc2RheSwgTWF5IDI3LCAy MDEwIDEyOjA3IFBN
DQpUbzogTXlTUUwNClN1YmplY3Q6IFZlcmlmeSBVc2VyIFByaXZpbGVnZXMN Cg0KSSB3b3VsZCBs
aWtlIHRvIGtub3cgaG93IEkgY2FuIHZlcmlmeSB3aGF0IHByaXZpbGVnZXMg aGF2ZSBiZWVuDQpn
cmFudGVkIHRvIGEgc3BlY2lmaWMgdXNlciBvbiBNeVNRTC4gSSBkb24ndCBy ZW1lbWJlciBpZiBt
eSB1c2VyDQonY2FybG9zJyBoYXMgc3BlY2lmaWMgcHJpdmlsZWdlcyBvbiAn bXlkYicgZGF0YWJh
c2UuIEkgYW0gc3VyZSBJIGNvdWxkDQpzaW1wbHkgcmUtcnVuIHRoZSBmb2xs b3dpbmcgY29tbWFu
ZDoNCg0KR1JBTlQgQUxMIFBSSVZJTEVHRVMgT04gbXlkYi4qIFRPICdjYXJs b3MnQCdsb2NhbGhv
c3QnDQogICAgLT4gICAgIFdJVEggR1JBTlQgT1BUSU9OOw0KDQpJIHJlYWxs eSB3b3VsZCBsaWtl
IHRvIGF2b2lkIHJlZHVuZGFudCBjb21tYW5kcyBpZiBJIGNvdWxkIHZlcmlm eSB0aGF0DQpteSB1
c2VyICdjYXJsb3MnIGFscmVhZHkgaGFzIHRoZSBuZWNjZXNzYXJ5IHByaXZp bGVnZXMgb24gdGhl
IHNwZWNpZmljDQpkYXRhYmFzZShzKSBpbiBxdWVzdGlvbi4NCg0KVGhhbmtz IGZvciBhbnkgaW5m
byAvIGhlbHAhDQoNCi1DYXJsb3MNCg0KLS0gDQpNeVNRTCBHZW5lcmFsIE1h aWxpbmcgTGlzdA0K
Rm9yIGxpc3QgYXJjaGl2ZXM6IGh0dHA6Ly9saXN0cy5teXNxbC5jb20vbXlz cWwNClRvIHVuc3Vi
c2NyaWJlOiAgICBodHRwOi8vbGlzdHMubXlzcWwuY29tL215c3FsP3Vuc3Vi PXJlZHdhcmRzQGxv
Z2ljd29ya3MubmV0DQoNCg==