Sunday, November 14, 2021

[SOLVED] MySQL password always prompt to reset password

Issue

There's something wrong with mysql after i updated it to newer version. It always prompts to reset my password everytime i boot/re-boot my laptop.

Is there any way to get out of this prompts? Where i can set my password without reset it everytime i open mysqlworkbench, and it's really horrible to change my mysql configuration on my codes everyday.

Here's the screenshot.

enter image description here

Thanks in advance.


Solution

For those who troubled by this problem, just reset your password like usual and you can run this command after you logged on to mysql

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

PS: I'm using MySQL 5.7.9 under Fedora 22



Answered By - sun station