List users from mysql.user

sql

SELECT user, host FROM mysql.user ORDER BY user, host;

Explanation

Requires appropriate privileges to inspect system tables.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing user management

Create an account identified by user name and host.

Open In sheetsqlsame section

Rotate credentials for an existing account.

Open In sheetsqlsame section

Remove an account from the server.

Open In sheetsqlsame section

Inspect who MySQL believes you are.

Open In sheetsqlsame section

Allow an app account to use one schema.

Give broad schema-level rights.