View User Permissions

Published: 2022-09-21
Updated: 2023-11-08

select user, host from mysql.user;
SHOW GRANTS FOR 'newuser';
SHOW GRANTS FOR 'newuser'@'192.168.1.5';