Problem
I want to see all Users with the command line tool.
Solution
pretty simple, login is as root and use
SELECT DISTINCT User FROM mysql.user;
this will output something like
User |
---|
root |
user1 |
user2 |
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
User |
---|
root |
user1 |
user2 |
2021 mysqlrecipes. All Rights Reserved.
Comments
Remo
This table contains more options showing you whether the account is active, what permissions it has an so on. Just try with a
*
:Leave a Comment