list users

lucycodes42

The SELECT statement retrieves all of the data from the mysql.user table. The user variable will contain the name of the user, the host variable will contain the name of the server on which the user account was created, and the password variable will contain the user's password.

Shortcut: user.list

SELECT `user`, `host`, `password` FROM `mysql`.`user`;