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