dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Intermediate
May 21, 2018

Understanding the GRANTS for the Current User in MySQL

The command "SHOW GRANTS" will display the privileges that the current user has.

Command: SHOW GRANTS

Sample output:

+------------------------------------------------------------------------------------------------------------------+
|Grants for dbuser@%                                                                                               |
+------------------------------------------------------------------------------------------------------------------+
|  GRANT ALL PRIVILEGES ON *.* TO 'dbuser'@'%' IDENTIFIED BY PASSWORD '*03E51IIDCEYB2B07FF7A98489A5C0E905A7087BC'  |
+------------------------------------------------------------------------------------------------------------------+

You can master the GRANT command to have varied output. Be cautious while using GRANT as you may be restricting the permission(s) to the user.

M S Sridhar
 
Thanks for your registration, follow us on our social networks to keep up-to-date