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