How to view privileges

      SELECT User, Host from mysql.user;
      

      SHOW GRANTS [FOR user];
      

      SHOW GRANTS FOR dba;
      

      SHOW GRANTS FOR mgs_user@localhost;
      

      SHOW GRANTS;
      

Description

• MySQL uses an internal database named mysql to keep track of its users. Within that database, MySQL uses a table named users to keep track of its users. You can query that table to get a list of users for the current MySQL server.
• You can use the SHOW GRANTS statement to show the privileges for a user.