Use the following SQL to list out all database users in MySQL.

select host, user from mysql.user;

Done =)

Reference: Alvin Alexander – MySQL show users – how to show the users in a MySQL database