Anal Crap ( no pun intended)

So my SO wants to try anal but I've never tried it and the thought terrifies me! He's been asking on and off for months now. My concerns are that people say it hurts so so bad, and I don't want poop everywhere 😣💩 
Is it as bad as it seems? Any advice to help?