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 user_admin@% |
+--------------------------------------------------------+
| GRANT ALL PRIVILEGES ON `db1`.* TO 'user_admin'@'%' |
| GRANT ALL PRIVILEGES ON `db2`.* TO 'user_admin'@'%' |
| GRANT ALL PRIVILEGES ON `db3`.* TO 'user_admin'@'%' |
+--------------------------------------------------------+
The output above indicates that the user user_admin has all privileges on the databases db1, db2, db3.
