how to check password for the current user in mysql code example

Example: mysql see users and passwords

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