So 2 seperate problems.
1) no prefix. did you change the config of your password query in the plugin to use the %P macro rather than %c?
2) "It seems to not change db to right one" what happens if you run the query manually?
1) I was using %p not %P, changed and now prefix is there.
2) It shows that query is competed successfully, but no changed are made. I use phpmyadmin. I have modified query so it looks more similar to phpmyadmin created.
Original string looks like this after I manually change something:
UPDATE `accounts` SET `password` = '{SHA512-CRYPT}$6$blā' WHERE `accounts`.`id` = 8;
RC log query:
UPDATE `accounts` SET `password` = '{SHA512-CRYPT}$6$blā' WHERE `accounts`.`username` = 'a@b.net';
Seems like query is the issue as it is not working in phpmyadmin also.
EDIT: I know what the issue is - username. RC tries to insert password in username a@b.net but db table is a part only, whit out @b.net. I don't know how to solve this.
EDIT2: I checked readme and config files and found that there is a macro %l that inserts username in form that i need. Now issue is that plugin changes password in db, but returns error that is was unsuccessful.