check user privileges mysql ubuntu code example

Example 1: mysql check user privileges

SHOW GRANTS FOR 'root'@'localhost';

Example 2: see mysql users ubuntu

SELECT User, Host FROM mysql.user;