MySQL WorkBench devs can’t change password

Posted on

Question :

I’m trying to create users for MySQL with the option for them to change the password:

enter image description here

But when Devs connect on Workbench, they receive a message:

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

I tried to find the answer but with no success.

How can I use this option and make devs be able to change their passwords on Workbench? Or do they need to log on Linux ?

Answer :

Try with an updated version of MySQL Workbench, the latest version currently is 8.0.26

If it doesn’t work, they will probably have to use a more “basic” tool like a shell “mysql”.

https://dev.mysql.com/doc/refman/8.0/en/expired-password-handling.html

You may also have to check what the disconnect-on-expired-password parameter is at :

https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_disconnect_on_expired_password

Leave a Reply

Your email address will not be published.