I am getting the below error for the user root@'%', but when I login through root@'localhost',I can see the password_expired = 'N' for root@'%'
Server version: 5.7.9-log MySQL Community Server (GPL)
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
+------+------+------------------+----------------+-------------------+-----------------------+
| user | host | password_expired | account_locked | password_lifetime | password_last_changed |
+------+------+------------------+----------------+-------------------+-----------------------+
| root | % | N | N | NULL | 2015-12-16 04:50:23 |
+------+------+------------------+----------------+-------------------+-----------------------+