devxlogo

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 GRANTSSample output:+——————————————————————————————————————+|Grants for dbuser@% |+——————————————————————————————————————+| GRANT ALL PRIVILEGES ON *.* TO ‘dbuser’@’%’ IDENTIFIED BY PASSWORD