see all users mysql
snippet in sql

see all users mysql

user8903

mysql> select host, user, password from mysql.user;

see mysql users ubuntu

user7642

SELECT User, Host FROM mysql.user;

show all users in mysql

user1786

mysql> select * from mysql.user;

display users in mysql

user4556

#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

user6211

SELECT user FROM mysql.user;