get all user data mysql code example

Example 1: how to show all users in mysql

SELECT user FROM mysql.user;

Example 2: show all users in mysql

mysql> select * from mysql.user;