To show the users in a MySQL database, first login as an administrative user, then run this query:

SELECT * from mysql.user;

This might show a large listing, so you may want to trim down some of the fields to display. You can get a listing of the fields in the mysql.user table by running this command:

desc mysql.user;

You can then use this listing to trim down your SELECT command.