It's only used once, in the SQL interface. The nuke password is meant for nuking the board, but since you can also nuke the board through the SQL interface...

You can't access that page unless you already have admin access, but here's a screenshot: http://www.wakachan.org/junk/sqlnuke.png