I must admit I've done something shameful on a production environment before.
After the initial "you fucking idiot!" calls were out the way and the issue was fixed, I actually got thanked for owning up.
I got the trust back in the end, but I think people appreciate knowing that they can trust you to own up to a mistake - instead of hiding and praying it isn't discovered.