Re: Can't update expired password in Mysql Workbench

[Henrique Garcia]

Hi, Don!
How are you?

I was able to reproduce the issue using MySQL Workbench 8.0.43 and MySQL Server 8.4.

Password changes performed manually work correctly:
SET PASSWORD FOR 'user'@'%' = 'new_password';

However, when the account password is expired:
ALTER USER 'user'@'%' PASSWORD EXPIRE;

and the user attempts to change the password through the Workbench "Reset Password" dialog, Workbench returns:
ERROR 1064 near PASSWORD('...')

This suggests that the password reset dialog is generating SQL that is incompatible with MySQL 8.4, while manual password changes continue to work normally.
Att, Henrique Garcia.