How to get a list of MySQL user accounts?

In MySQL, you can get list of user account with user details. Just execute following Query of PHPMySQL/SQL Yog/Other MySQL Tools.

List of MySQL users.

SELECT User FROM mysql.user

List of MySQL unique users.

select distinct User from mysql.user;

List of MySQL users with password and host.

SELECT Host,User, Password FROM mysql.user

List of MySQL unique Users with password and host.

SELECT Host,User, Password FROM mysql.user  group by User

List of MySQL users with all permissions.

SELECT * FROM mysql.user WHERE 1

Best Related Posts are Following:

1. DBMS Interview Questions and Answers for Freshers.
2. MySQL Interview Questions and Answers for Experienced.
3. Difference between inner join and outer join in MySQL.
4. How to get a list of MySQL user accounts?.
5. What is MySQLI technology in php.
6. How to delete MySQL Binary logs Files in Wamp Server?.
7. SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 2269548 for key PRIMARY.
8. Multiple column ordering in Zend Framework.
9. Mysql Privileges - Types of privileages in MySql - How do I grant privileges in MySQL.
10. Difference Between Primary Key And Unique Key And Foreign Key And Composite Key.
11. Difference Between MyISAM and innoDB - MySQL.
12. MySQL Functions - MySQL tutorial for beginners.
13. mysqlsubqueries examples Scalar Subqueries Row Subqueries Column Subqueries Table Subqueries.
14. Mysql FullText Search Examples.
15. MySQL Constraint Example.
16. MySQL Cascade Example.
17. Mysql-Group-Concat.
18. MySQL Expressions.
19. MySQL Delete Table Example.
20. Replace Table - Update Field, Move Records to another table MySQL.
21. mysql insert syntax - Add records from another table - Copy Table from one table to another.
22. Mysql Update Syntax - Update Multiple Records.
23. What is Mysql.
24. Mysql Console Commands - Export and Import database from command line.
25. MySQL interview Questions and Answers For Experienced.