View User Permissions

Chester Wyke September 21, 2022 Updated: April 26, 2025 #SQL

SQL (Series)
Add New User to Database
Install and Setup
View List Of Users
Misc
View User Permissions
Reset Root Password
Temp Admin
Install MySQL

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