display users in mysql
snippet in sql

mysql show users

user6051

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

show list of users in mysql

user7901

//To show all data use following query
select * from mysql.user;
// To show user and host use following query
select User,Host from mysql.user;

display users in mysql

user7083

#display all user data
select * from mysql.user;
#display username and host
select user, host from mysql.user;

how to show all users in mysql

user2526

SELECT user FROM mysql.user;