Try changing the password column in table users_secure for the username wanted to change to:
$2y$10$6nlFnmFSwPYq/y7E8jhbX.ijYCIX7M4J9cmkQupzs.uHm4z8F.x7O
This is for user admin so if this doesn’t work(unsure if we include username in encryption) let me know.
Umm you did run sql_upgrade.php from browser, right?