| Viewed 183 times

How to get all user accounts in MySQL


I need to get all accounts from the command line

1 Answer
Mohammad Qandeel
Answered
18

this query will fetch all user 

SELECT User FROM mysql.user;

the output 

+------+
| User |
+------+
| root |
| root |
| root |
| pma  |
| root |
+------+


Related Questions