Skip to Main Content

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MySQL 5.6 Password Expired and Oracle SQL Developer

daniel_haukeJul 10 2018 — edited Aug 24 2018

Hi everybody,

we want to create a type of password expiration procedure for database users in mysql, which worked well so far.

But now we wanted to connect to the mysql database via Oracle SQL Developer and change the expired password.

But it seems that this isn't possible, because it throws the following error:

"An error was encountered performing the requested operation: You must SET PASSWORD before executing this statement"

I think it comes from the behaviour of Oracle SQL Developer, that he wants to changed the database right after the connection is established (like USE test_db).

Does anybody knows a way that i can connect with an user with an expired password via Oracle SQL Developer an change it by executing SET PASSWORD?

Greetings Daniel

Comments

Post Details

Added on Jul 10 2018
4 comments
422 views