MySQL - How to list all users?
How to list all MySQL users?
1. Using query editor
From the query editor, run this query:
SELECT user FROM mysql.user;
Or if you want to see the corresponding host name to the user:
SELECT user,host FROM mysql.user;
Or to get list of unique user:
SELECT DISTINCT user FROM mysql.user;
2. Using TablePlus GUI
In TablePlus, you can see the list of MySQL users and manage these users via the user management feature.
When connected to the database, navigate to menu Connection > User Management…, you will the all MySQL users listed there.
Need a good GUI Tool for MySQL? TablePlus is a modern, native tool with an elegant UI that allows you to simultaneously manage multiple databases such as MySQL, PostgreSQL, SQLite, Microsoft SQL Server and more.
Not on Mac? Download TablePlus for Windows.
On Linux? Download TablePlus for Linux
Need a quick edit on the go? Download TablePlus for iOS.
