RE: Verify User Privileges

2010-05-27 Thread Rolando Edwards
ards -Original Message- From: Rolando Edwards [mailto:redwa...@logicworks.net] Sent: Thursday, May 27, 2010 12:39 PM To: Carlos Mennens; MySQL Subject: RE: Verify User Privileges SHOW GRANTS FOR 'carlos'@'localhost'; Rolando A. Edwards MySQL DBA (CMDBA) 155 Avenu

Re: Verify User Privileges

2010-05-27 Thread Maurice
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 s

RE: Verify User Privileges

2010-05-27 Thread Rolando Edwards
-Original Message- From: Carlos Mennens [mailto:carlosw...@gmail.com] Sent: Thursday, May 27, 2010 12:07 PM To: MySQL Subject: 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 &#x

Re: Verify User Privileges

2010-05-27 Thread Carlos Mennens
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 archi

Verify User Privileges

2010-05-27 Thread Carlos Mennens
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' ->