SELECT User,Host FROM mysql.user;
snippet in sql

see all users mysql

user6923

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

SELECT User,Host FROM mysql.user;

user7422

SELECT User,Host FROM mysql.user;
DROP USER 'testuser'@'localhost';