View User Permissions

Chester Wyke September 21, 2022 Updated: April 15, 2025 #sql
select user, host from mysql.user;
SHOW GRANTS FOR 'newuser';
SHOW GRANTS FOR 'newuser'@'192.168.1.5';