How to Check permissions of user / login in MySQL Server - MySQL DBA Tutorial

How to check what permissions user / login has in MySQL Server


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


MySQL > 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.


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


MySQL complete tutorial for beginners - How to check privileges of user in MySQL Server