Same problem. I've had 10.6.5 on my machine for some time, but when I logged out last night, and disconnected an ipod and an external HD, it seems to have caused a glitch; when I tried to log back in all the (five) user accounts were gone, replaced with user "Other". None of the accounts names + passwords will log into this.
I have tried Disk Repair from the CD, and although it fixed some things, I still have no user accounts.
I'm reluctant to reload Snow Leopard if there is a simpler cure - my next plan is to boot up from my old Leopard CD and see if I can fix anything that way.
What is the best cure for this problem, with the least chance of losing data (needless to say my last TM backup is rather out of date).
Cheers.