Keep in mind that in AMP 8+, there's an additional column 'is_enabled' that should be set to 1. You may also need to reset 'login_attempts' as well (by default, the max login attempts is 10 tries before account is disabled).
# dbc "select * from users where username='admin';"
-[ RECORD 1 ]---+-------------------------------------------------------------------------------------------------------------------------------
id | 1
username | admin
password | 2cf94b0aea63ebf7bf41c90fe500603e
role_id | 5
full_name | admin
email | admin@blank.com
phone | 555-555-5555
notes |
password_format | md5
login_attempts | 0
is_enabled | 1