see mariadb users code example
Example: mariadb check users
-- User only:
SELECT User FROM mysql.user;
-- User + Host:
SELECT host, user FROM mysql.user;
-- User only:
SELECT User FROM mysql.user;
-- User + Host:
SELECT host, user FROM mysql.user;