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.