select host user password from mysql.user code example

Example: see all users mysql

mysql> select host, user, password from mysql.user;