see password of user mysql code example

Example 1: mysql see users and passwords

SELECT User, Host, Password, password_expired FROM mysql.user;

Example 2: select password from user mysql

mysql> SELECT host,user,authentication_string FROM mysql.user;