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