I see you are digging in your database , change the value in the confirmed-field from 0 to 1 and you have a workaround.
But you have to get your mail working. It is used in several other places in Moodle. Normaly, if you leave the SMTPhosts-option in the configurationsheet empty, it works.
Good luck.