Turn off MySQL Password Expiry

By devin, 24 November, 2015

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

Plain text

  • No HTML tags allowed.
  • Web page addresses and email addresses turn into links automatically.
  • Lines and paragraphs break automatically.