Understand Permissions Granted to a User in MySQL
July 17, 2018
3:07 pm
In MySQL, you can know the permissions granted to an user using the following statement. We will now use this code to find the permissions available for user user_admin. This example is for illustration only. mysqlSHOW GRANTS FOR user_admin Sample output: +——————————————————–+| Grants for [email protected]% |+——————————————————–+| GRANT ALL PRIVILEGES ON