How to retrieve list of mysql users?

Mysql users are stored into ‘mysql’ db and ‘user’ table, therefore to retrieve the list of all registered users, simply execute the following query:

select * from mysql.user;

or, for a less detailed list:

select User, Host, Password from mysql.user;


Post a Comment

Your email is never published nor shared. You're allow to say what you want...