I want to see all Users with the command line tool.
pretty simple, login is as root and use
SELECT DISTINCT User FROM mysql.user;
this will output something like
This table contains more options showing you whether the account is active, what permissions it has an so on. Just try with a *:
SELECT * FROM mysql.user
This table contains...
by Gi Tios
2017 mysqlrecipes. All Rights