MySQL “show users”: How to show/list the users in a MySQL database

To show/list the users in a MySQL database, first log into your MySQL server as an administrative user using the mysql command line client, then run this MySQL query:

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