SHOW GRANTS FOR 'carlos'@'localhost'; Rolando A. Edwards MySQL DBA (CMDBA)
155 Avenue of the Americas, Fifth Floor New York, NY 10013 212-625-5307 (Work) 201-660-3221 (Cell) AIM & Skype : RolandoLogicWorx redwa...@logicworks.net http://www.linkedin.com/in/rolandoedwards -----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 '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=redwa...@logicworks.net