System

Display list of MySQL User Accounts

datatainment datatainment |

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
datatainment

Comments

Remo

Remo

3 years ago

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

Leave a Comment

Please sign-in to post a comment