How can I find out if a user's password has expired in MySQL?
This information, along with other user properties, is found in the user table in the mysql schema (database). The value 'Y' would indicate an expired password 

select password_expired from mysql.user where user = 'whatever'