mysql -u root -p -e "SELECT user, host, plugin FROM mysql.user;"

Category: Databases & SQL

mysql -u root -p -e "SELECT user, host, plugin FROM mysql.user;"

List users with auth plugins

Shows every account with the host it may connect from and the authentication plugin it uses, including the default root entries. A quick security audit of who can log in and how.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.