Recover A Locked Root User Account

To unlock a locked Root Account in the Registry you will need access to the underlying database that stores all of the Registry information.

Identify the 'registry_root_security' table.

sql> select * from registry_root_security;
+----------+-----------+-----------+--------------------------------------------------------------+
| username | is_locked | max_login | pwd                                                          |
+----------+-----------+-----------+--------------------------------------------------------------+
| root     |         0 |        -1 | $2a$10$DvnMm3u74kaWQnWzkG0kqOpPd8TEQl2wdxa0laTxwCkGb8W421ena |
+----------+-----------+-----------+--------------------------------------------------------------+

This table contains the following information about the root account: the username; the password (encrypted); the number of times a wrong password can be entered before the account is locked; whether or not the root account is locked.

To unlock a locked root user set the value of the column 'is_locked' to 0. There is no need to restart the Registry after this change, the root user is now unlocked.