MYSQL show user permission

 https://www.shellhacks.com/mysql-show-users-privileges-passwords/#:~:text=Show%20User%20Privileges%20In%20MySQL,have%20connected%20to%20the%20server.

mysql> SHOW GRANTS FOR 'user_name';

Show privileges granted to a particular MySQL user account from a given host:

mysql> SHOW GRANTS FOR 'user_name'@'host';

– e.g. –

mysql> SHOW GRANTS FOR 'root'@'localhost';
mysql> SHOW GRANTS FOR 'root'@'%';
mysql> SHOW GRANTS FOR 'admin'@'192.168.0.1';