Share This Article:

Subscribe to Kavoir:

To show all MySQL databases, you can simply type SHOW DATABASES; or SHOW TABLES; to show all tables of the current database. However, if you want to list and display all the MySQL users, SHOW USERS; won’t work.

So how to display a list of the MySQL users?

As all user information such as user name and privilege data are stored in the table user of the database mysql that comes automatically created and populated after MySQL installation. You can show all the MySQL users of the current host by the following select query:

SELECT user FROM mysql.user;

Which would output a list of rows of all the active users, in the same format of what a SHOW DATABASES; would do.

Share This Article:

Subscribe to Kavoir:

You should also read:

• MySQL, PHP: Display MySQL table fields and data
• MySQL: How to export a database / table to XML?
• MySQL: How to backup ALL databases as root with mysqldump at once?
• MySQL: Get the exact size of a database by SQL query
• MySQL: Export Table to CSV Text Files for Excel