Turn off MySQL Password Expiry

The other day my computer begain repeatedly giving me this MySQL error:

Your password has expired. To log in you must change it using a client that supports expired passwords.

It happened to my root account and my Devin account. I searched online quickly and found out (after more looking than I'd hoped for) how to change my password.... but the problem came back a few days later.

Here's what I ended up finding at https://dev.mysql.com/doc/refman/5.7/en/password-expiration-policy.html:

ALTER USER 'script'@'localhost' PASSWORD EXPIRE NEVER

Phew!

Tags: 

Add new comment