mysql users explained code example

Example: mysql show users

select * from mysql.user;
#or for less data
select user, host from mysql.user;