Show all MariaDB users and hosts

List all users, their host, and authentication method. Run inside the MariaDB shell.

Queries the mysql.user system table to list all database users and their allowed host patterns. Useful for auditing who has access.

When you need this: When auditing database access or troubleshooting authentication failures.