Turn off MySQL Password Expiry

Submitted by devin on Tue, 11/24/2015 - 22:24

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