Is anal really as painful/scary as it seems?

Charlee
So a while back I had a bad experience with anal sex and now my boyfriend who I've been with for two years wants to try it. Im willing to do it just very nervous. Are there tips or anything I should know beforehand​? I already got a shit-ton -no pun intended, of lube. Thank you