mysql> select user,host,password_expired from mysql.user; +-----------------+----------------+------------------+ | user | host | password_expired | +-----------------+----------------+------------------+ | root | localhost | N | | root | jrhdpt01 | N | | root | 127.0.0.1 | N | | root | ::1 | N | | zjzc_app | 10.171.243.55 | N | | zjzc_app | 10.252.148.164 | N | | quartz_app | 10.171.243.55 | N | | quartz_app | 10.252.148.164 | N | | | query_dev | % | N | | zjzc_limit_cn | % | N | | backup | % | N | | zjzc_dba | localhost | N | | admin_query_all | % | N | | monitor | % | N | +-----------------+----------------+------------------+ 16 rows in set (0.00 sec)