I had never changed the password of my `root` user before and it's password has never expired. Now I have to change its password and I will be using this code to do it:

```
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('StrongPassword');
SET PASSWORD FOR 'root'@'%' = PASSWORD('StrongPassword');

```

Will the password expire anytime soon? If so how can i query to know the expiry date?

**In Oracle, I use**

```
select
     ACCOUNT_STATUS
    ,USERNAME
    ,EXPIRY_DATE
from
    DBA_USERS
;

```

Is there anything like it in **MySQL** that I should be concerned about?