MariaDB Tutorial

Display a list of users

To see the list of users, view the contents of the "mysql.user" table.

select * from mysql.user;

Since the column is long, it will be easier to see if you use "\ G" to display it vertically.

select * from mysql.user \ G