how to check mysql username and password correct code example

Example: mysql see users and passwords

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