In , you can know the to an 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 `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.



Source link

LEAVE A REPLY

Please enter your comment!
Please enter your name here