select * from mysql.user;<br /><br /><br /> #or for less data<br /><br /><br /> select user, host from mysql.user;

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

mysql> select host, user, password from mysql.user;<br /><br /><br />

#display all user data<br /><br /><br /> select * from mysql.user;<br /><br /><br /> #display username and host<br /><br /><br /> select user, host from mysql.user;

mysql> select * from mysql.user;<br /><br /><br />

// login to mysql as root<br /><br /><br /> mysql -u root -p<br /><br /><br /> // use mysql database<br /><br /><br /> use mysql;<br /><br /><br /> // list users<br /><br /><br /> select user,host from user;

mysql> select user,host from user;<br /><br /><br /> +——————+———–+<br /><br /><br /> | user | host |<br /><br /><br /> +——————+———–+<br /><br /><br /> | admin | % |<br /><br /><br /> | mysql.infoschema | localhost |<br /><br /><br /> | mysql.session | localhost |<br /><br /><br /> | mysql.sys | localhost |<br /><br /><br /> | root | localhost |<br /><br /><br /> +——————+———–+

sudo mysql # first run this command to login mysql<br /><br /><br /> select user, host from mysql.user;

# List All Unique Usernames<br /><br /><br /> SELECT DISTINCT User FROM mysql.user;<br /><br /><br /> # List All Usernames + Hostnames;<br /><br /><br /> SELECT User,Host FROM mysql.user;

$ mysql -u root -p //login with root<br /><br /><br /> Enter password: *********<br /><br /><br /> mysql> use mysql; //use mysql<br /><br /><br /> Database changed.<br /><br /><br /> mysql> SELECT user FROM user; //show userlist