How to see Permissions of a user in MariaDB

How to see Permissions of a user in MariaDB

Once you are login to MariaDB, you can run below statement to see the permission of currently login user account.

MariaDB > Show Grants'

If you want to check the permissions of other users, you can do as long as you have the permissions to do by using below statement.

MariaDB > SHOW GRANTS FOR 'UserName'@'HostName';